Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(13 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: Is there a change in the connectivity technology to SQL Server databases from PowerCenter 9.6.0?
Answer
Case 1: SQL Server is used as PowerCenter (on Windows) Repository Service database
Case 2: SQL Server Native connectivity is used to read/write data from SQL Server sources/targets with PowerCenter on Windows
 
For the above cases 1 and 2, prior to PowerCenter 9.6.0, SQL Server Native Client Object Linking and Embedding, Database (SNAC OLEDB) technology was used to connect to the SQL Server database. But with Microsoft announcing the depreciation of Microsoft SQL Server (SNAC) OLEDB Provider, starting PowerCenter 9.6.0, for the connectivity to SQL Server for above cases, SQL Server Native Client Open Database Connectivity (SNAC ODBC) is used instead of SNAC OLEDB.
 
 
The SQL Server Native client package can be downloaded from the following URL and this installer installs the SQL Server native client drivers for SQL Server versions 2005, 2008, and 2012: http://www.microsoft.com/en-in/download/confirmation.aspx?id=29065
Note

 

SNAC should be installed on the Informatica Server machine.

Same case is applicable for Data Quality sources as well because it uses native connectivity while reading or writing data from/to the DB sources.
 
In the above download link, the ​SQL Server Native client package is located under the following:
Install Instructions > MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS > Microsoft® SQL Server® 2012 Native Client
 
Case 3: For connecting to SQL Server source/target with PowerCenter server on supported UNIX environments DataDirect ODBC connectivity is being used as before.

Important

  • When SNAC (Microsoft SQL Server 2012 Native Client) is installed from the above link, the following drivers would be seen in the ODBC driver manager:
    *SNAC (for SQL Server 2005)
    *SNAC 10.0 (for SQL Server 2008)
    *SNAC 11.0 (for SQL Server 2012)                                 
    For connectivity to both SQL Server 2008 and 2012 SNAC 11.0 libraries would be used and not SNAC or SNAC 10.0 for the SQL Server native connections.
  • No change required on the connections in the Workflow Manager / Repository Service connection details.
    Automatically the SNAC 11.0 libraries will be used for connecting to the SQL Server for the native Microsoft SQL connections and the Repository Service.
    NOTE:
    SNAC 11.0 libraries support SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014 only.
    https://msdn.microsoft.com/en-us/library/cc280356.aspx

The following screenshot depicts the new drivers. Note that an ODBC DSN need not be created for using native connections. The screenshot is only to show that the underlying libraries of these ODBC drivers are used to connect to SQL Server via native connection.

 
160118.png

More Information

Applies To
Product: PowerCenter; Data Quality
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter 9.6.0; PowerCenter 9.6.1; Data Quality 9.6; Data Quality 9.6.1
Database: Microsoft SQL Server 2008; Microsoft SQL Server 2008 R2; Microsoft SQL Server 2012; Microsoft SQL Server 2014
Operating System:
Other Software:

Reference

Attachments

Last Modified Date:6/16/2015 11:57 PMID:160118
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)