Skip to Content

SAP Hana EIM Connection Scenario Setup - part 2

Install the sybfilter and start it

Share the folder which contain the log file .ldf and the log with the dp agent server

In the dp agent server in order to map the relationship of the directory of the database edit the mssql_log_path_mapping.props file in the logreader config directory

And finally check the TCP/IP enablement on the SQL server

SQL server is ready, I can register my adapter and create my remote connection

Now completed let’s move to DB2 database setup

IBM DB2 10.5 LogReader adapter

In order to have DB2 working with LogReader few step needs to be achieved, I will first add a new pool buffer and a temporary user tablespace, turn DB2 in archivelog mode on and create a specific user for the replication.

You can either do it over command line or using the studio.

Check the current log setting

And last step is to create the OS technical user (ra_user) for the replication

And grant the necessary privileges to the user

Now completed I can register my adapter and create my remote connection

Sybase ASE adapter setup

The SAP ASE adapter provides realtime replication and change data capture functionality to SAP HANA or back to a virtual table.

In the interface file add the additional necessary entries:

  • The entry name must be the same as the Adapter Instance Name specified when creating remote source.
  • The host name or IP must be the name of server where SAP ASE adapter will be running.
  • The port must be the same as the SAP ASE Adapter Server port that you set up in the ASE adapter interface file, located in <DPAgent_root>/Sybase/interfaces.

From an ASE perspective I’ll create 2 users which are required when the remote connection is created from Hana

rep_user : for replication with the role “replication”

mnt_user : for maintenance

Once done register your remote adapter and create the remote source in Hana

The connection completed we can start the other configuration for Teradata

Teradata adapter setup

For my Teradata database, I will use the revision 15.0 packaged from the Teradata website for ESXi available at the following link “Teradata Virtual Machine Community Edition for VMware

In order to create a remote connection another account is require with the following select privilege on “dbc” tables:

  • "DBC"."UDTInfo"
  • "DBC"."DBase"
  • "DBC"."AccessRights"
  • "DBC"."TVM"
  • "DBC"."TVFields"

Once done register your remote adapter and create the remote source in Hana

Note : The official documentation on SP10 doesn’t mention that you need to load the jdbc driver of Teradata into the lib folder of the dp agent.

You can download this driver from the Teradata website according your revision and extract it into the lib directory

Link to :

SAP Hana EIM  Connection Scenario Setup - Part 1

SAP Hana EIM  Connection Scenario Setup - Part 3

Tags:

No comments