informatica mysql的配置,Linux安装Informatica的环境变量及ODBC配置

Linux安装Informatica的环境变量及ODBC配置

作者：利小宏

发布于：2016-6-10 13:20

3361次浏览

#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

本文出自 @利小宏，转载时请注明出处及相应链接。