Monday, 8 June 2015

How to connect to microsoft sqlserver from Informatica using odbc driver ?

How to connect to sqlserver from Informatica using odbc driver?

Step1: set up the .odbc. ini file with the below entry. You will have to enter the proper path for your driver and information for your database.

[MYSQLSERVER]
Driver=/data/informatica/ODBC6.1/lib/DWmsss25.so
Description=DataDirect SQL Server Wire Protocol
Database=mydatabase
LogonId=mysuerid
Password=mydatabase
Address=machinename,1433
QuotedId=No
AnsiNPW=No

Step 2: set up the relational odbc connection from your workflow manager as shown in screenshot below.