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.
- 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).
Replace $LINK_DIR with actual Data Services Install folder path above.
- 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.