Sybase IQ - Informatica - External Loader Feature [ Bulk load ] without exposing user nam and password

[sathish jo]

Hi All,

Is it possible to use Informatica for Sybase IQ Bulk load [ External
Loader feature ] , without exposing user name and password in
connection string.

Example for connection string :
uid=dba;pwd=sql;eng=IQServerName;links=tcpip(host=IQHostMachineName;port=2638)

We don't want to disclose the user name and password to Informtica
ETL users for security reasons.

We need Informtica Sybase IQ Bulk load feature as well.

Appreciating your valuable inputs.

http://www.sybase.com/detail?id=1069086

Sathish J

[Leonid Gvirtz]

Hi Satish

I have never worked with Informatica, but the format of the connection string in your example looks just like a regular IQ connection string, I suppose that there is nothing Informatica-specific here. If so, you can specify ODBC alias (dsn) instead, then user/password information will be stored in ODBC alias definitions and will not be exposed to Informatica directly. You can use ODBC both on Windows and Unix/Linux.

Hope it helps
Leonid Gvirtz
http://www.gvirtz-consulting.com

---

From: sathish jo <sathish...@gmail.com>
To: iqug <iq...@googlegroups.com>
Sent: Mon, April 5, 2010 3:33:08 PM
Subject: [iqug] Sybase IQ - Informatica - External Loader Feature [ Bulk load ] without exposing user nam and password

--
You received this message because you are subscribed to the Google Groups "iqug" group.
To post to this group, send email to iq...@googlegroups.com.
To unsubscribe from this group, send email to iqug+unsub...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/iqug?hl=en.

[Sathish J]

Hi Leonid ,

Even I am new to informatica , I don’t find any ODBC connection options for External Loader feature [ bulk load]  in Informatica.

Thank you for your reply and consideration. Looking for more alternatives / work around  .

Regards ,

Sathish J

 

 

To unsubscribe from this group, send email to iqug+uns...@googlegroups.com.

[Mark]

There is a whitepaper that describes how to make it work at:

 

http://www.sybase.com/detail?id=1069086

 

There is an updated whitepaper that will outline further details of fixing Informatica’s lack of full support for parallel loads.  This is expected out shortly.

 

-- Mark

[Sathish J]

 

 

My concern is using Informatica - External Loader Feature without exposing user name and password in connection string.

 

This below whitepaper is using connection string with user name and password in External Loader. 

 

Is there any alternative in External Loader feature of informatica , so i no need to disclose user name and password to Informatica ETL users.

 

Appreciating your response.

 

Regards ,

Sathish J