Kettle connection Cluster Environment configuration, kettle Cluster Environment

Kettle connection Cluster Environment configuration, kettle Cluster Environment

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/43705063

 

Find jdbc in the Kettle root directory. properties file (Reference Directory: D: \ soft \ Kettle \ data-integration \ simple-jndi), add a connection RAClink (JNDI connection name) in the configuration file ).

 

RAClink/type = javax. SQL. DataSource

RAClink/driver = oracle. jdbc. driver. OracleDriver

RAClink/url = jdbc: oracle: thin: @ (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP) (HOST =Server IP1) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST =Server IP2) (PORT = 1521) (CONNECT_DATA = (FAILOVER_MODE = (TYPE = select) (METHOD = basic) (SERVICE_NAME =Rac)))

RAClink/user =UserName

RAClink/password =UserPassword

 

Parameter description:

Server IP1: Replace the IP address of oracle cluster node 1

Server IP2: Replace the IP address of oracle cluster node 2

Rac: Replace the SID of the Cluster

UserName: Replace the Login User Name

UserPassword: Replace the Login User Password

 

Follow this configuration to connect to the cluster database. You can change the tnsnames configuration in the cluster client according to the actual situation.

 

The configuration for kettle connection is shown in:

 

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/43705063