How to do the connectivity test for various databases from Informatica server.

  • To check the Oracle database connectivity from the Informatica server.
         Step 1: Log in to Informatica server.
         Step 2 : Use the following command to connect to database
          sqlplus user_name/password@databse_name
  • To check the Teradata database connectivity from Informatica server.
       Step 1: Log in to Informatica server.
       Step 2 :  Just hit bteq
       bteq
       Step 3 :  Use the .logon command to connect to teradata database.
       .logon dbc_name/user_name;
        Password :
  • To check connectivity for any of the databases which are connecting through the odbc entries
        Step 1 : Log in to Informatica Server get  In to the $ODBC_HOM/lib path.
       Step 2 : Use the following command for connectivity test.
       ssgodbc.solaris64  –d odbc_entry_name –u user_name –p password –v
  • To check the sybase connectivity from Informatica server.

     Step 1 : Log in to server.

     Step 2 : Use the following command to test the connectivity.

      isql -Uuser_name -Ppassword -Ddb_name -Sserver_name

Popular Posts

Featured Post

Basic unix commands used in Administration

ls –ltr                Shows all the files and sub directories in the  current directory. ls –la                  Shows all the hidden...