Linux安装Informatica的环境变量及ODBC配置
#vi .bash_profile
# oracle #
export ORACLE_BASE=/u01
export ORACLE_HOME=$ORACLE_BASE/oracle
export ORACLE_SID=orcl
export NLS_LANG="american_america.UTF8"
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
# informatica #
export LANG=en_US.UTF-8
export INFA_CODEPAGENAME="MS936"
export INFA_HOME=/u02/Informatica/9.5.1
export CLASSPATH=.:$ORACLE_HOME/lib:$INFA_HOME/server/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$INFA_HOME/ODBC7.0/lib:$INFA_HOME/server/bin:$LD_LIBRARY_PATH
export PATH=$INFA_HOME/server/bin:$PATH
export INFA_DOMAINS_FILE=/u02/Informatica/9.5.1/server/domains.infa
# informatica ODBC #
export ODBCHOME=$INFA_HOME/ODBC7.0
export PATH=$PATH:$ODBCHOME/bin
export LD_LIBRARY_PATH=$ODBCHOME/lib:$LD_LIBRARY_PATH
export ODBCINI=/u01/oracle/.odbc.ini
社区版的mysql需要安装unixODBC,和mysql-odbc驱动
# isql -v MYSQL5
# yum install *unixODBC* *mysql-connector-odbc*
# cat /u01/oracle/.odbc.ini
[ODBC Data Sources]
SQL2008=DataDirect 7.0 SQL Server Legacy Wire Protocol
MYSQL5=DataDirect 7.0 MySQL Wire Protocol
[ODBC]
IANAAppCodePage=4
InstallDir=/u02/Informatica/9.5.1/ODBC7.0
Trace=0
TraceFile=odbctrace.out
TraceDll=/u02/Informatica/9.5.1/ODBC7.0/lib/DWtrc26.so
[SQL2008]
Driver=/u02/Informatica/9.5.1/ODBC7.0/lib/DWsqls26.so
Description=DataDirect 7.0 SQL Server Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadOptions=2
BulkLoadRecordDelimiter=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=infa_rep
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=192.168.140.129
HostNameInCertificate=
InitializationString=
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=sa
MaxPoolSize=100
MinPoolSize=0
PacketSize=-1
Password=123456
Pooling=0
PortNumber=1433
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XMLDescribeType=-10
[MYSQL5]
#Driver=/u02/Informatica/9.5.1/ODBC7.0/lib/DWmysql26.so
Driver=/usr/lib/libmyodbc5w.so
Description=DataDirect 7.0 MySQL Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=test
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
HostName=127.0.0.1
HostNameInCertificate=
InteractiveClient=0
LicenseNotice=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order
to use the DataDirect Connect for ODBC for MySQL Enterprise driver with MySQL software.
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
LogonID=root
LoginTimeout=15
MaxPoolSize=100
MinPoolSize=0
Password=123456
Pooling=0
PortNumber=3306
QueryTimeout=0
ReportCodepageConversionErrors=0
TreatBinaryAsChar=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
# oracle #
export ORACLE_BASE=/u01
export ORACLE_HOME=$ORACLE_BASE/oracle
export ORACLE_SID=orcl
export NLS_LANG="american_america.UTF8"
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
# informatica #
export LANG=en_US.UTF-8
export INFA_CODEPAGENAME="MS936"
export INFA_HOME=/u02/Informatica/9.5.1
export CLASSPATH=.:$ORACLE_HOME/lib:$INFA_HOME/server/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$INFA_HOME/ODBC7.0/lib:$INFA_HOME/server/bin:$LD_LIBRARY_PATH
export PATH=$INFA_HOME/server/bin:$PATH
export INFA_DOMAINS_FILE=/u02/Informatica/9.5.1/server/domains.infa
# informatica ODBC #
export ODBCHOME=$INFA_HOME/ODBC7.0
export PATH=$PATH:$ODBCHOME/bin
export LD_LIBRARY_PATH=$ODBCHOME/lib:$LD_LIBRARY_PATH
export ODBCINI=/u01/oracle/.odbc.ini
社区版的mysql需要安装unixODBC,和mysql-odbc驱动
# isql -v MYSQL5
# yum install *unixODBC* *mysql-connector-odbc*
# cat /u01/oracle/.odbc.ini
[ODBC Data Sources]
SQL2008=DataDirect 7.0 SQL Server Legacy Wire Protocol
MYSQL5=DataDirect 7.0 MySQL Wire Protocol
[ODBC]
IANAAppCodePage=4
InstallDir=/u02/Informatica/9.5.1/ODBC7.0
Trace=0
TraceFile=odbctrace.out
TraceDll=/u02/Informatica/9.5.1/ODBC7.0/lib/DWtrc26.so
[SQL2008]
Driver=/u02/Informatica/9.5.1/ODBC7.0/lib/DWsqls26.so
Description=DataDirect 7.0 SQL Server Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadOptions=2
BulkLoadRecordDelimiter=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=infa_rep
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=192.168.140.129
HostNameInCertificate=
InitializationString=
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=sa
MaxPoolSize=100
MinPoolSize=0
PacketSize=-1
Password=123456
Pooling=0
PortNumber=1433
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XMLDescribeType=-10
[MYSQL5]
#Driver=/u02/Informatica/9.5.1/ODBC7.0/lib/DWmysql26.so
Driver=/usr/lib/libmyodbc5w.so
Description=DataDirect 7.0 MySQL Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=test
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
HostName=127.0.0.1
HostNameInCertificate=
InteractiveClient=0
LicenseNotice=You must purchase commercially licensed MySQL database software or a MySQL Enterprise subscription in order
to use the DataDirect Connect for ODBC for MySQL Enterprise driver with MySQL software.
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
LogonID=root
LoginTimeout=15
MaxPoolSize=100
MinPoolSize=0
Password=123456
Pooling=0
PortNumber=3306
QueryTimeout=0
ReportCodepageConversionErrors=0
TreatBinaryAsChar=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1