Performing a Simple Replication - Adabas to Relational Database
This tutorial replicates a table from an Adabas database to a SQL Server database. If you do not have access to SQL Server, Microsoft provides a free version called SQL Server Express Edition. For more information, see Microsoft's web site.
Prerequisites
Install Adabas version 6.1.4 or above.
Install CONNX Data Integration Suite 1.1.2 or above.
Install Adabas Event Replicator for LUW.
Create an Adabas database with a DBID of 1 using the Adabas sample tables. For this example, we will be using the Adabas sample table EMPLOYEES-NAT (File11)
Start the Adabas database.
Have a SQL Server database available. For this tutorial, we recommend that you create a database named Replication. Otherwise, you can use any existing SQL Server database.
To start a replication, you need to:
1. Create a CDD Containing the source and target databases.
2. Set the CDD Security.
3. Create a Replication.
Create a CDD containing the source and target databases
The first step is starting the CONNX Data Dictionary:
1. Start the CONNX Data Dictionary. The Open window appears.
2. Click Cancel. The CONNX Data Dictionary Manager window appears.
Importing the Adabas source tables
1. Click Import. The Import CDD window appears.
2. Select FDT Import in Import Type. Type "1" in Database ID. Type 255 in MAX ADABAS File #. Type in the logon information.
CAUTION:
Do not use localhost as the server name for the Adabas Source tables. In certain instances using localhost as the server name may cause you to lose all your source table records during an initial state.
3. Click OK. The CONNX Import Table Selection window appears
4. Select ADABAS_FILE_11 and click Add.
5. Click OK. The ADABAS Count Selection window for the source table appears.
6. Accept the default values and click OK. The CONNX Data Dictionary Manager window containing the source table information appears.
7. Rename the database from localhost to DBID1. In the CONNX Data Dictionary window, click localhost (ADABAS). Click Rename. On the Rename Object window type DBID1.
Importing the Target Database
1. Click Import. The Import CDD window appears.
2. Select SQL Server in Import Type.
3. Click OLEDBC Provider in Select Provider Type. Click Select Provider. The Data Link Properties window appears. Select Microsoft OLEDB Provider for SQL Server and click Next. The Data Link Provider appears.
4. Fill in the window based on your SQL Server installation and click OK. The CONNX Import Table Selection window appears.
5. If there are any tables in your SQL Server database, they will appear in Available Tables. Click Add All and then click OK. The CONNX Data Dictionary Manager window appears.
6. Rename the target database to SQLTarget.
Set the CDD Security
1. Clear Security -> Default Access = Read Only.
2. Click File -> Save As.
3. Name your CDD Adabas to Relational Replication and click Save.
4. Close the CONNX Data Dictionary Manager.
Create a Replication
1. Start the Replication Administrator. The Open the Data Dictionary window appears.
2. Select Adabas to Relational Replication.cdd and click Open. The Configure Servers window appears.
3. In CONNX Logon Credentials, enter your sample in UserName; leave the Password field blank. Click Test Connection. The CONNX Integrated Logon window appears.
4. Leave the Password field blank and click OK.
5. You will be prompted to create a user in the CDD. Press OK. The User ID sample will be created with a blank password.
6. When the connection succeeds, enter localhost in Name/Address and 9200 in Port.
7. Click Done. The Add Tables window appears.
8. From Select source tables, select DBID1.dbo.ADABAS_FILE_11. From Select Target Databases, select SQLTarget.
9. Click OK. The Adabas Event Replicator for LUW window appears.
10. Click Active and then Deploy.
11. Click the Server Status tab. Verify that the Replication Server, Source Database and Source - Target Group contain Replicating in State Description.
This completes a simple Adabas to relational database replication. You can do inserts, updates, and deletes against the ADABAS_FILE_11 in database 1 and the changes will replicate to your SQL Server database.