In addition, for SAP HANA and IBM DB2 only, add the following parameter definition to the DSN in your odbc.ini file to avoid buffer overflows during connection: DriverUnicodeType=1 Note: The libspssodbc_datadirect_utf16.so wrapper is also compatible with the other SPSS Modeler Server supported ODBC drivers.
![]() Purpose
Here is a simple example of an ODBC driver connecting to Databases for Smart Data Analytics.
Overview
To connect to Databases such as Adaptive Server Enterprise(ASE) an ODBC driver is needed. By default the HANA ODBC Driver is setup, but others are not.
unixODBC
unixODBC is a 3rd party tool to house ODBC drivers from different companies. This product uses 2 different configuration files to store information regarding ODBC drivers.
odbc.ini - this holds database information
odbcinst.ini - this holds driver library location
Default location for these files in SDS:
/hana/shared/<HANA ID>/streaming/cluster/<HANA ID lowercase>/config
odbc.ini:
[ASE] Description=ASE ODBC Driver Driver=Adaptive Server Enterprise UserUD = sa password = sapassword Server = databasehost Port = databaseport
odbcinst.ini:
[HDBODBC] Description=64-bit HANA ODBC Driver Driver=/hana/shared/<HANA ID>/hdbclient/libodbcHDB.so FileUsage=1
[Adaptive Server Enterprise]
Description=64-bit HANA ODBC Driver Driver=<SDK for SAP ASE installation directory>/DataAccess64/ODBC/lib/libsybdrvodb.so
Note: You can add ODBC tracing by adding this to the top of your odbcinst.ini file:
[ODBC] Trace = yes TraceFile = <some directory>/sql.log ODBC in SDS
To add an ODBC driver to SDS:
Adapter
Generic_DB_input or Generic_DB_output can be used to connect to the Databases.
Database Service Name = DSN / <odbc.ini name in bracket>
Related ContentRelated DocumentsRelated sap notes/kbasSkip to end of metadataGo to start of metadataSap Hana Odbc DriverPurpose
Here is a simple example of an ODBC driver connecting to Databases for Smart Data Analytics.
Overview
To connect to Databases such as Adaptive Server Enterprise(ASE) an ODBC driver is needed. By default the HANA ODBC Driver is setup, but others are not.
unixODBC
unixODBC is a 3rd party tool to house ODBC drivers from different companies. This product uses 2 different configuration files to store information regarding ODBC drivers.
odbc.ini - this holds database information
odbcinst.ini - this holds driver library location
Default location for these files in SDS:
/hana/shared/<HANA ID>/streaming/cluster/<HANA ID lowercase>/config
odbc.ini:
[ASE] Description=ASE ODBC Driver Driver=Adaptive Server Enterprise UserUD = sa password = sapassword Server = databasehost Port = databaseport
odbcinst.ini:
[HDBODBC] Description=64-bit HANA ODBC Driver Driver=/hana/shared/<HANA ID>/hdbclient/libodbcHDB.so FileUsage=1
[Adaptive Server Enterprise]
Description=64-bit HANA ODBC Driver Driver=<SDK for SAP ASE installation directory>/DataAccess64/ODBC/lib/libsybdrvodb.so
Note: You can add ODBC tracing by adding this to the top of your odbcinst.ini file:
[ODBC] Trace = yes TraceFile = <some directory>/sql.log ODBC in SDS
To add an ODBC driver to SDS:
Adapter
Generic_DB_input or Generic_DB_output can be used to connect to the Databases.
Database Service Name = DSN / <odbc.ini name in bracket>
Related ContentRelated DocumentsOdbc Driver 64-bitRelated sap notes/kbasComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2020
Categories |