top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
442 views

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?

posted Jul 17, 2014 by Amit Sharma

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

1 Answer

0 votes

You can access any database from any server if you have the driver installed on the the client.

If the client os supports the database, you can get the client installed there. If not, you can always get the cess channel through ODBC.

answer Jul 18, 2014 by Shweta Singh
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?

+2 votes
Update from one table to another table using SQL Server 2008

I want to update data from one table to another table with year condition.
(OR)
To Update one table based on another table using INNER JOIN

+1 vote
Converting the time column SQL server to timestamp column in oracle using Informatica

I have a Time column in my SQL Server table which has data like (14:00:00.0000000).

I am trying to load this type of data in Oracle table which has corresponding column datatype as timestamp. I am trying to convert the time column in SQL server to timestamp column in oracle using Informatica.

Whats the best way to do it?

0 votes
Informatica: reduced performance for simplet one to one mapping when target change from Oracle to SQL Server

I have simple informatica(9.1) mapping(one to one) which loads data from flat file to RDBMS

it take 5 mins to load to Oracle db and 20 mins to load same file in SQL Server 2008 R2.

Can there be any source/pointers for performance improvement

+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)

...