Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Data Services ODBC drivers are bundled with Data Services Installation and are installed in $LINK_DIR/DataDirect folder. They can be used to connect various data sources such as: DB2, Informix, MySQL, OpenEdge, Oracle, Postgre SQL, SQL Server, Sybase.

Note :

  • Beginning Data Services 4.2 native connection to Microsoft SQL Server is supported The data store should be Microsoft SQL Server as Data store type rather than ODBC With this connecting to SQL Server from Linux Job server does not need any additional configuration on the Linux server
  • Whenever possible try to use native connection rather than DataDirect or generic ODBC Always check PAM for supported connectors

1. Create a ODBC data source ( E.g. TestDataSource ) on Windows box where designer is running. Create a data store (E.g. TestDataStore ) with type as ODBC using that ODBC data source in Data Services Designer.

2. On Data Services Linux machine add the data source to the Unix ODBC driver manager configuration file ($LINK_DIR/bin/ds_odbc.ini).

[TestDataSource]
Driver = $LINK_DIR/DataDirect/odbc/lib/libodbc.so 
OdbcConformanceLevel=
LazyLoading=
ODBC64SqlHandleSize=64
ODBC6SqlLenSize=64
RebrandedLib = TRUE

Replace $LINK_DIR with actual Data Services Install folder path above.

Note:

  • RebrandedLib = TRUE is required when using the SAP BusinessObjects Rebranded Data Direct driver.

3. For DataDirect ODBC $ODBCINI should point to $LINK_DIR/DataDirect/odbc/odbc.ini. It contains template specification for various types of databases  You can add the data source to the ODBC vendor's configuration file or edit existing one in $ODBCINI or $LINK_DIR/DataDirect/odbc/odbc.ini 

  • Data source name should be exact same one as in ds_odbc.ini  or as specified when creating ODBC data source on Windows
  • Specify attributes like Database name, schema name port, server name whatever applicable. You need not specify database username and password in this file as that is something the data services engine retrieves from the ODBC datastore and passes to the ODBC driver.
  • The template specification in $ODBCINI has some default parameters values, if you want to leave a specific connection parameter blank, remove any comments after "=" sign, if there are any. E.g. Change: ParamName=<Your Param Name Here> to ParamName= if you are not specifying anything for ParamName.

     

    4. Add the following environment settings to the session running the job service:
ODBCINI=$LINK_DIR/DataDirect/odbc/odbc.ini
LD_LIBRARY_PATH=$LINK_DIR/DataDirect/odbc/lib:$LD_LIBRARY_PATH
export ODBCINI LD_LIBRARY_PATH

ODBC connections from a Linux (or UNIX) jobserver

To configure Teradata ODBC on Linux and Unix

  • No labels

5 Comments

  1. Hi Kendra,

     We have an environment where our Job server is on Unix

     

    DS 4.2 SP5

    Source/Target Database: SQL Server 2014

    Repository Database: Oracle 11G R2

     

    • Beginning Data Services 4.2 native connection to Microsoft SQL Server is supported The data store should be Microsoft SQL Server as Data store type rather than ODBC With this connecting to SQL Server from Linux Job server does not need any additional configuration on the Linux server

    Kendra Vangundy, Can you please confirm if this is applicable for DS 4.2 SP5

    Regards

    Arun Sasi

     

  2. sorry for delayed response, yes this would work on all DS 4.2

  3. Former Member

    Hello there!

    Doing new connection for FireBird but no luck. Managed to connect to Postgresql, it was hard, but succeed, because there is PG driver in DataDirect. But FireBird got no *.so in DataDirect folder.

    Any additional settings to be done?

     

    Regards,

    Yury

  4. I am not sure if DataDirect drivers shipped with DS do support FireBird. You can install any other level-2 compliant driver and add the ODBC datasource entry in $ODBCINI as well as in $LINK_DIR/bin/ds_odbc.ini

  5. Former Member

    Hello Aasavari!

    What is $ODBCINI?

    Am I right that I shouldn't use odbc.ini file, only ds_odbc.ini?

     

    Regards, Yury