How to create Data connection in Datastage

Data connection is a technique used for the re-usability of stage mandatory property values. 
Steps to create Data Connection 

Click on Oracle Enterprise– Click on Stage– Click on Data Connection 

You will get two options like 

a) Load Data Connection 

b) Save Data Connection 

Click on Save Data Connection 

Now Give Data Connection name ( User Defined ) 

Give Data connection name ( User Defined ) 

Give Some Description for that Connection 

In parameters, give your server name of database and 

User name = Give your user name in Database 

Password = The Password you are using for that id. 

Than click ok and Save 

Leave a Reply

Your email address will not be published. Required fields are marked *