top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Protocols For Informatica Architecture

+2 votes
297 views

Before I can gain VPN access to run Informatica from home, I need to identify all the protocols Informatica uses for an ETL job to run. I found that it uses a native protocol for the repository, source, and target databases (so sqlnet for Oracle). I also know that I'll need to identify all protocols that could potentially be used to extract data from non-RDBMS sources (such as ftp).

But, what protocol would be used to connect to the server to run the job? Are there any other protocols I'd need to be aware of that it might use as part of the whole process of opening up Designer, creating a job, and running it?

posted Mar 27, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

If you are going to access Informatica through vpn, you need not worry about anything on protocols side. With VPN, you actually join the local network of the server and therefore no need of any configuration on the vpn itself.

answer Mar 27, 2014 by Shweta Singh
Similar Questions
0 votes

Sql case statement is selecting the records but not returning the conditions in informatica

ex. Select *,case if emp_de = 'M' and leave is not null then 'Yes',when if emp_de = 'M' and leave is null then 'No' As 'Remark' end from EMP table where emp_Sal <2000.
the query is working fine in the informatica but the condition Yes or No not updating in the Remark port.

...