on 2024 Aug 21 3:14 PM
Dear Experts,
we have installed a Data Provisioning Agent and we have connected it to a Hana Database.
Now on the Hana Database, we need to create a Remote Source to a Microsoft SQL Server database, running on a Windows Server platform.
Unfortunately, creating a remote source in Hana Studio seems not to be working anymore (we only see the indexserver, but not the dpagent). Hana Cockpit is not available.
As a workaround, we are creating the remote source using a SQL statement:
CREATE REMOTE SOURCE "YourRemoteSourceName"
ADAPTER "MssqlLogReaderAdapter"
AT LOCATION AGENT "YourAgentName"
CONFIGURATION '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ConnectionProperties>
<PropertyEntry name="Data Server (serverName[\\instanceName])">YourServerAddress:YourPort\\YourInstanceName</PropertyEntry>
<PropertyEntry name="Database name">YourDatabaseName</PropertyEntry>
<PropertyEntry name="User Name">YourUsername</PropertyEntry>
<PropertyEntry name="Password">YourPassword</PropertyEntry>
</ConnectionProperties>'
WITH CREDENTIAL TYPE 'PASSWORD'
USING '<CredentialEntry name="db_credential">
<user>YourUsername</user>
<password>YourPassword</password>
</CredentialEntry>';
The statement executes successfully, the remote source is being created, but unfortunately it does not work 😞
In the log file of the Data Provisioning Agent framework.trc, we have the following error:
[ERROR] [62f2fa52-f6a9-499b-b57f-e87d77d6ba1a28772] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: Adapter validation failed. Failed to validate properties. Error(s):
Property [Password] is mandatory.
Property [Data Server (serverName[\instanceName])] is mandatory.
Property [User Name] is mandatory.
Property [Database name] is mandatory. Context: com.sap.hana.dp.cdcadaptercommons.validation.ValidationException: Failed to validate properties. Error(s):
Property [Password] is mandatory.
Property [Data Server (serverName[\instanceName])] is mandatory.
Property [User Name] is mandatory.
Property [Database name] is mandatory.
at com.sap.hana.dp.cdcadaptercom...
PLEASE provide help and advice! Many thanks!
You need to install first the MS SQL ODBC client on the HANA DB server (Linux) in order to be able to connect.
The official documentation is here: https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-fo...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello mamartins, many thanks for your answer! I think your suggestion is for ODBC connection. Up to my knowledge, this is only suitable for SDA, not for SDI. And we are using the MssqlLogReaderAdapter. Do we have to use a different adapter ? According to my knowledge, there is no other adapter suitable for SDI in connection with a Microsoft SQL Server database. Is our SQL statement for creating the remote source correct ? Many thanks!
User | Count |
---|---|
61 | |
10 | |
10 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.