Configure Connection to Sybase

Learn about user privileges required on the database side to connect to Oracle GoldenGate and configuration instructions to set up connections for Sybase to Oracle GoldenGate.

Prepare Database Users and Privileges for Sybase

Oracle GoldenGate requires a database user account. Create this account and assign privileges according to the following guidelines.

• To preserve the security of your data, and to monitor Oracle GoldenGate processing accurately, do not permit other users, applications, or processes to log on, or operate as, the Oracle GoldenGate database user.

• Create a database user that is dedicated to Oracle GoldenGate. It can be the same user for all of the Oracle GoldenGate processes that must connect to a database:

  • Extract (source database)

  • Replicat (target database)

  • DEFGEN utility (source or target database)

• The Extract process requires permission to access the source database. Do one of the following:

  • Grant System Administrator privileges.

  • Assign a user name with replication_role . The command to grant replication role is either:

sp_role 'grant', replication_role, *Extract_user*

Or

use *dbname* grant role replication_role to *Extract_user*

Note: Specific DDL or DML operations may require the use of both sa_role and replication_role.

• The Replicat process requires connect and DML privileges on the target database.