Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« AWS Offerings for Dummies | Main | Introduction to Oracle Analytics Cloud - OAC »

Configuring Task Flow dependency and Teradata ODBC connection in Informatica cloud

In this blog, I am going to cover Configuring dependency between the two task flows and configuring ODBC connection for Teradata relational Database in Informatica cloud.

This blog will help to run one task flow when the dependent task flow completed successfully and create an ODBC connection to connect Teradata Relational Database which can be used in Mappings/Data Synchronization/Data Replication jobs to load/retrieve the data.

Configuring Task Flow dependency

In real time, we would require the taskflows to run in certain order or in other words, we should trigger a task flow (taskflow2) after the completion of a task flow (taskflow2). This can be achieved by runajobcli package. This package helps to triggering a taskflow from command prompt (API call). 

Steps to configure the package and trigger the task flow

 

Step 1: Ask Informatica cloud support to activate the Runajob package on the secure agent or ORG if it is not already available.

Step 2: Configure restenv.properties file present in below path

Path: C:\Program Files\Informatica Cloud Secure Agent\downloads\package-runAJobCli.2\package\

 

Step 3: Give full control access to the Informatica cloud installed folder to the user (secure agent installed user).

Step 4: Try to call one dummy task from command prompt by going to the runajob package path.

Ex: C:\Program Files\Informatica Cloud Secure Agent\downloads\package-runAJobCli.2\package\

    cli.bat runAJobCli -n W_ETL_RUN_D_AMDOCS_End_MCT -t MTT

Step 5: If you get 'java internal external command not found', then add java path environment variable in 'My computer'->Advanced properties

EX: Add- C:\Program Files\Informatica Cloud Secure Agent\jre\bin(C or D directory)  

Step 6: Then try to call the same command from post processing command of the MCT. If you get the java error in the log, then add full java path to CLI.bat file

Example CLI.bat: @echo off

pushd %~dp0"Informatica Cloud Secure Agent\jre\bin\java.exe" -cp .;runAJobCli.jar;lib\* com.informatica.saas.utilities.plugins.RunAJobPlugin %* popd @echo on

or

@echo off

pushd %~dp0"D:\Apps\Informatica Cloud Secure Agent\jre\bin\java.exe" -cp .;runAJob

 

Configuring Teradata ODBC Connection

To establish Teradata ODBC connection in Informatica cloud you would require below utilities which can downloaded from below URL

https://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package


Once you have downloaded follow the below steps

Step 1: Run the installer (.exe) from the Downloaded directory and Choose the Language and click on 'Next'.

Step 2: Installation Wizard will be opened. Click on 'Next'.

 

Step 3: Accept the License Agreement by clicking 'I accept the terms in the license agreement' and click on 'Next'.

Step 4: After selecting destination folder , Click on 'Next'.

Step 5: Do check 'ODBC Driver for Teradata *' and Click on 'Install'.

Step 6: Click on 'Finish'.

Step 7: Run the installed one more application file from the following path :

EX:D:/TeradataODBC_windows_indep.15.10.17.00/TeradataODBC/x64/SharedICU-64bit

Step 8: Click on 'Next'.

Step 9: Accept the License Agreement by clicking 'I accept the terms in the license agreement' and click on 'Next'.

Step 10: Click on 'Finish'.

Step 11: Run one more installed application file from the following path

EX: D:/TeradataODBC_windows_indep.15.10.17.00/TeradataODBC/x64\TeraGSS-64bit

 

Click on 'Next'.

Step 12: Select 'Modify' and click on 'Next'.

 

 

Step 13: Select the required feature and click on 'Next'.

Step 14: Click on 'Install' to start installation.

Step 15: Under System DSN, set the ODBC Driver Setup for Teradata Database by providing user Name and PWD And click on 'OK'.

Step 16: Test the ODBC connection in command prompt.

Step 17: Using the ODBC connection you've created, you can create a 'New connection' in Informatica Cloud.

Step 18: If test connection fail, restart the secure agent and try again.


Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles