When you configure IBM InfoSphere CDC, you are prompted for the host name and port number of the solidDB® server you want IBM InfoSphere CDC to connect to and replicate data. Before installing IBM InfoSphere CDC, ensure that this solidDB® database exists and that you have created and set up a database user that has access to it.
Setting up a solidDB® account with SYS_ADMIN_ROLE privileges
Create and set up a solidDB® user and assign DBA privileges to this user. For IBM InfoSphere CDC to connect to your solidDB® database, you need to create a solidDB® user account and assign SYS_ADMIN_ROLE privileges to this user. When you configure IBM InfoSphere CDC, you are prompted for the host name and port number of the solidDB® server you want IBM InfoSphere CDC to connect to and the user name and password of the solidDB® user that has access to this database.
Creating a solidDB® schema
Create a schema or choose an existing schema for your IBM InfoSphere CDC database metadata tables. You will have to specify this schema when you configure IBM InfoSphere CDC.
Setting up a Windows user account for IBM InfoSphere CDC
If you are installing IBM InfoSphere CDC on a Windows system, you must set up a new, or decide on an existing Windows account that you will use to install, configure, or upgrade IBM InfoSphere CDC.
Setting up a Linux or UNIX user account for IBM InfoSphere CDC
If you are installing IBM InfoSphere CDC on a Linux or UNIX system, you must set up a new, or decide on an existing Linux or UNIX account that you will use to install, configure, or upgrade IBM InfoSphere CDC. You can install IBM InfoSphere CDC in the directory of your choice, however, it must be owned by the Linux or UNIX account.