Skip to Content
0
Jun 02, 2022 at 01:43 PM

Need help connecting a SQL Server DB to Data Warehouse Cloud

1080 Views Last edit Jun 03, 2022 at 11:40 AM 4 rev

Greetings,

I need to connect an external DB (SQL Server) to Data Warehouse Cloud. I found that it is possible to do this with the help of a DP Agent, where you would use a MsSqlLogReaderAdapter, which would later be configured to read transaction logs and get access to data on the DB. I managed to install the correct driver and enable the adapter, but then I ran into other problems while trying to configure it. Because my DB is located on a different machine than the DP Agent, I used this guide for reference:

https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/7952ef28a6914997abc01745fef1b607/1311229d81ea474b948cb9684d9e5e43.html?version=2.0_SPS00

Here I do not understand how to configure Sybfilter (2nd step). I copied the Sybfilter files from my DP Agent and tried to run the installation.

At first I tried running the sybfiltermgr.exe file within the folder and it gave me this error:

mstsc-m6ibzhi2an.png

Then I installed the driver like this:

mstsc-boup5ppm6q.png

It seems like it added the sybfilter file to the System32 directory. But how am I supposed to configure it? I found another guide on how to do this:

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00269.1571/doc/html/bde1279759298452.html

Here it says that the sybfilter driver installation directory is located at '%SYBASE%\RAX-15_5\system\ <platform'. However there is no such directory (%SYBASE% folder does not exist) on my machine (Windows server 2012). Am I missing something? Do I even need to configure the sybfilter driver?

EDIT:

If I try to validate my connection on the DWC website, it returns me this error:

image.png

Attachments

image.png (17.4 kB)