top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Database connectivity with Informatica and SQL Server 2008 R2

+1 vote
277 views

I have installed Informatica 8.6 on Vmware and SQL Server 2008 R2 installed on my local host. I am not able to connect the Informatica with SQL Server 2008 R2.

Kindly help me as soon as possible.

Thanks in advance

posted Sep 1, 2014 by Sachin

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
0 votes
I want to install SQL Server database in my system and add this database to Informatica which has oracle already

I have Informatica 9 and an Oracle database in my system. Now I want to install a SQL Server database in my system and add this database to Informatica.

Is that possible ?

Purpose: I need to migrate some of the tables from SQL Server to Oracle database using informatica.

Could anyone let me know, after installing SQL Server, how can I add this SQL Server database to informatica for creating mapping?

0 votes
How to access SQL Server database in one host from informatica pc in another box

I installed informatica PC8.6 on Windows XP and SQL Server 2008 R2 on another machine. How can I access this database from informatica pc.8.6. and is it possible to access?

+2 votes
Joining null in SQL Server, Oracle and informatica?

I have two tables to join with a column (say emp_id).. if emp_id in both the tables have null values, how will SQL Server and Oracle treat???

I read that informatica will neglect the NULL rows when joining..if I handle the null, by substituting -1, a cross-join will happen which i don't want..

What can I do here? (I cannot completely neglect the rows which has NULL)

...