Bewerken

Delen via

Access the CDC Designer Console

  • Artikel

You can access the CDC Designer Console from the computer where you installed the console. For more information about installation, see Installation.

When you open the CDC Designer Console, the Connect to SQL Server dialog box opens.

The SQL Server login that accesses the CDC Designer must have UPDATE permissions on the MSXDBCDC database. In addition, the login must also have the dbcreator fixed-server role to create new Oracle CDC Instances. It is recommended that the login also have SELECT access to the CDC databases being used or the user will not be able to view the state of those databases.

Enter the following information in the Connect to SQL Server dialog box.

Server Name

Type the name of the server where the SQL Server is located.

Authentication

Select one of the following:

  • Windows Authentication

  • SQL Server Authentication: If you select this option, you must type the Login and Password for the user in the SQL Server you are connecting to.

The login must have a database role that allows access to the MSXCDCDB database. It is recommended that the login also have access to any additional databases being used or the user will not be able to view the data in those databases.

Options

Click the arrow to view available options to be configured. You can choose to leave these options with their default value. The available options are:

Connection Timeout
Type the time (in seconds) that the CDC Service for Oracle waits for a connection to the SQL Server before timing out. The default value is 15.

Execution Timeout
Type the time (in seconds) that the Oracle CDC Windows Service waits for a command to execute before timing out. The default value is 30.

Encrypt Connection
Select Encrypt Connection for communication between the Oracle CDC Service and the target SQL Server instance using an encrypted connection.Advanced: Click Advanced and type any additional connection properties into the Advanced Connection Properties dialog box, if necessary.

Advanced
Click Advanced and type any additional connection properties into the Advanced Connection Properties dialog box, if necessary.

For information about the Advanced Connection Properties dialog box, see Advanced Connection Properties.

See Also

SQL Server Connection Required Permissions for the CDC Designer