Server Defined Connection Strings

One way to produce portable assembly lines is to define your connection strings in the solution.properties file and set your connectors to load them. This allows you to use one assembly line and have the server define where it connects to for Dev/Test/Prod

First, define some properties in your workspace's solution.properties file. 

sudo vim /opt/IBM/TDI/V7.2/solution.properties  

# Drop down to the end
...
...

## Some Database
org.gattis.ord1.jdbc.url=jdbc:oracle:thin:@server.gattis.org:3060:ORD1
org.gattis.ord1.jdbc.username=scott
{protect}-org.gattis.ord1.jdbc.password=tiger

The next time DI starts it will hash any values starting with the {protect} key and you'll end up with a more secure line that looks like:

{protect}-org.gattis.ord1.jdbc.password={encr}adsfasLKSJDLKjlk33#$sdflkj


Next, configure your connector to use this property.



Comments