See Trademarks for appropriate markings. Menu Skip to content. I have configured the Informatica server 9. The Informatica installation includes DataDirect 6. If there is an error then check the environment variables above. Notify me of new comments via email. This tool uses JavaScript and much of it will not work correctly without it enabled.

Uploader: Tebar
Date Added: 24 January 2017
File Size: 30.49 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 60671
Price: Free* [*Free Regsitration Required]

Comments are disabled in preview mode.

How to configure ODBC for Informatica in Linux Server to connect to SQL Server – Tank Liu’s Techlog

Powered by Progress Sitefinity. You are commenting using your Facebook account. View all posts from Paul Griffin on the Progress blog.

Nice infodmatica i am searching this from long time now i got it you helped me a lot thanks for sharing…. If there is an error then check the environment variables above. Set the connection properties as follows:.

How Informatica Uses DataDirect ODBC Drivers to Supercharge Application Performance

You cannot post a blank message. While all of these solutions sound compelling in theory, you may be wondering how DataDirect customers actually utilize our products in practice. Fill in your details below or click an icon to log in: Post was not sent – check your email addresses! See Trademarks for appropriate markings. Robust Ensure high availability via application failover and workload balancing without changing application code.


This site uses cookies. If the error still occurs, then change the line to: Correct Answers – 4 points. Services Consulting Education Modernization Outsourcing. Learn about the top 10 reasons high-performance why data connectivity is critical for your business. Fast Outperforms other drivers in throughput, CPU utilization and satadirect usage. Notify me of new comments via email.

If run workflow with odbc connection with other ODBC drivers, isql testing outside Informatica succeeded while connection failed inside Informatica environment.

But connection to these two data source failed with iSQL. Meanwhile we informaatica the sql server native client Email required Address never made public. For additional information on this scoring system, refer to https: The conclusion is; it is possible to connect to “Microsoft SQL Server Driver for Linux” using the Data Direct ODBC drivers shipped with Informatica ,however as this is unsupported by Informaticathorough testing is required to make sure all the functionalities work.


Fast High-performance data loading built-in.

Verify that the last entry in the odbc. Failed to connect to database using user [sa] and connection string [infatest].

Connect Database driver error Versatile Supported on every major platform and certified to work with leading applications such as Tableau, Informatica, Cognos, Business Objects and more.

So current status is: Please enter a title. To find out more, including how to control cookies, see here: You are commenting using your Twitter account.

UTF8 or vice versa. Secure Includes robust SSL data encryption and user authentication.