| title | Connect to Oracle | |
|---|---|---|
| description | Connect to Oracle | |
| author | chugugrace | |
| ms.author | chugu | |
| ms.date | 03/01/2017 | |
| ms.service | sql | |
| ms.subservice | integration-services | |
| ms.topic | concept-article | |
| f1_keywords |
|
[!INCLUDE oracle-cdc-retirement]
When you add or edit the tables used in the CDC instance for the first time, you may be asked to connect to the Oracle database. You should enter the credentials of an Oracle user who can access the schema of the tables to be captured. Enter the following in this dialog box:
Authentication
Select one of the following:
-
Windows Authentication: Select this to use the current Windows domain credentials. You can use this option only if the Oracle database is configured to work with Windows authentication.
-
Oracle Authentication: If you select this option, you must type the User Name and Password for the user in the Oracle database you are connecting to.