1,Oracle Connection Object
/opt/oracle/product/11g/network/admin/tnsnames.ora
SEUATW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracnbj019)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SEUATW)
)
)
2,Mircosoft SQL Server Connection Object
/app/Informatica/9.0.1/ODBC6.0/odbc.ini
[msss_target]
Driver=/app/Informatica/9.0.1/ODBC6.0/lib/DWmsss24.so
Description=DataDirect 6.0 SQL Server Wire Protocol
Address=sqlvvbj019, 3486
AlternateServers=
AnsiNPW=Yes
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=Target
LoadBalancing=0
LogonID=
Password=
QuotedId=No
ReportCodePageConversionErrors=0
IANAAppCodePage=113
[ODBC Data Sources]
data_source_name = myodbc5