Configure DataDirect ODBC on UNIX with PowerCenter

Do the following to install DataDirect ODBC drivers on UNIX: Install the Informatica Services which include the DataDirect ODBC drivers for UNIX. Set the ODBCHOME environment variable  > ODBCHOME=/opt/Informatica/9.6.1/ODBC7.1; export ODBCHOME Add the $ODBCHOME/bin directory to the PATH environment variable: Using a Bourne shell: $ PATH=${PATH}:$ODBCHOME/bin; export PATH Using a C shell: $ setenv PATH ${PATH}:$ODBCHOME/bin  Add the $ODBCHOME/lib to the library path variable. (OPTIONAL) Copy the odbc.ini file to the location where you would like this file to be used. Typically the Informatica home directory is used. cp $ODBCHOME/odbc.ini $HOME/.odbc.ini Set the ODBCINI environment variable to the location of the .odbc.ini (or odbc.ini) file:  $ ODBCINI=$HOME/.odbc.ini; export ODBCINI OR $ ODBCINI=$ODBCHOME/odbc.ini; export ODBCINI Edit the odbc.ini file (specified by the $ODBCINI environment variable) as follows: Set the InstallDir to the ODBC installation directory ($ODBCHOME). Re-Start the Informatica Node services.

How to Create alias in windows and unix operating system

This article shows how to create a alias in both windows and Unix command prompt.

1. Windows:

1. Open the command prompt. ( Run -> type "cmd" and hit enter.

2. use the below command to create an alias.

            doskey <alias>=<command>

For ex : if i want to set alias sys to connect the database i use the below command.

* doskey sys=sqlplus system/oracle

Now if you type sys it will directly connect to the database by running the sqlplus command.

UNIX:

Now we will see how to create alias in Unix operating system.

1. Login to bash shell.

2. Below is the command used to create an alias in UNIX.

* alias <alias_name>=<command>

For ex : if i want to set l to run the command ls -lrt use the below command.

alias l="ls -lrt"

When you type l it will run the command you have set for this alias.

MBP:~ nirmalg$ alias l="ls -lrt"

MBP:~ nirmalg$ l

total 0

drwxr-xr-x+  4 user1  staff   128 Mar 29 16:37 Public

drwx------+  5 user1  staff   160 Apr  9 22:01 Pictures

drwxr-xr-x   6 user1  staff   192 Apr 24 06:57 Applications

MBP:~ nirmalg$