Originally posted by: Santanu

Hi,

Prerequisite to Connect Oracle DB using ITX in Unix

======================================

We need to have Oracle client installed in the Unix env, tnsname.ora file in the admin directory with connection parameter details,PATH,ORACLE_HOME and LIBRARY_PATH environment variables need to be configured properly so that when we will deploy MDQ in Unix then it can connect to DB.

 

Like wise can you please help me the setup details need to be followed to connect MS SQL SERVER using ITX 9.0 in Unix env.

 

Thanks

Santanu

#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: GertieKearney

Hi,

 

You would need to use the Transformation Extender (TX) ODBC adapter to connect to MS SQL Server on Unix environment.

 

Using the TX ODBC Adapter is described in the Release notes.

 

Release notes for Transformation Extender, V9.0.0.3
http://www-01.ibm.com/support/docview.wss?uid=swg27051084#odbc_adap

 

There are two environment variables (ODBCINI and the library path) that are set for ODBC when the TX setup script is ran.

$ cd <tx_install>
$ . ./setup

 

ODBCINI=<tx_install>/odbc_drivers/odbc.ini

 

For AIX:

LIBPATH=<tx_install>/odbc_drivers/lib:$LIBPATH

 

For Linux and Solaris

LD_LIBRARY_PATH=<tx_install>/odbc_drivers/lib:$LD_LIBRARY_PATH

 

The odbc.ini file needs to be configured to contain a specific DSN that is defined to connect to the specific database.The DSN is then used by the TX ODBC Adapter to connect to the specific database.

 

ODBC Adapter

https://www.ibm.com/support/knowledgecenter/SSVSD8_9.0.0/com.ibm.websphere.dtx.adapodbc.doc/topics/g_odbc_ODBC_Adapter.htm

 

You can enable the ODBC database adapter trace to capture any error information.

 

Trace (-T or -TRACE)

https://www.ibm.com/support/knowledgecenter/SSVSD8_9.0.0/com.ibm.websphere.dtx.adaps.doc/references/r_adapterslib_Trace_T_or_TRACE.htm

 

I hope this information is of help.

 

Gertie.

#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Santanu

Thank you so much Gertie for your time and help

#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Santanu

Hi Gertie,

 

Can't we use MS SQL SERVER adapter in unix & Windows to connect the DB?

 

Thanks

Santanu

#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: GertieKearney

Hi,

 

You can use the MS SQL Server on Windows to connect to database but you would need to use the Transformation Extender (TX) ODBC adapter to connect to MS SQL Server on Unix environment.

 

Gertie.

#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Santanu

Thank you so much

 

Have a nice day and weekend ahead.

 

#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender