ps77322

 Profile Answers by ps77322 

• Nov 5th, 2009

 

Connection String Creation:
First go to the Work flow manager and then select your folder, then go to Connections menu and select Relational and select the type of database from the drop down and click on new button. enter the details like name of connection string, username and password and connect string (connect string =database server name or can be obtained from the TNS copy and paste the host name when u are looking in the TNS)
then finally click on ok.

Creating a Session:
First go to the Work flow manager and then select your folder, then go to Task developer and then Select Create on Tasks Menu. Select Session from the drop down and link the associated mapping when it prompts. Go to the Mappings and give the relevent information for Source and targets and then save it

Running:
Create a work flow linking the created session and save. Process is same as that of creating a session ..instaed of selecting Session from the dropdown select Workflow.

Now right click on the wrk flow and select start task..