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

537 views

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?

posted Apr 28, 2014 by Pooja Bhanout

Share this question

Facebook Share Button

Twitter Share Button

LinkedIn Share Button

1 Answer

Installing the SQL server software on your system and getting informatica to talk to that are entirely different things.
1.You can for sure install SQL server on your Informatica server system, till the time you are dealing with some varient of Windows. Informatica can be installed on *nix flavours but not SQL server. If your informatica server is not on windows varients, you need to have a separate windows box for sql server installation.

2.Getting informatica to talk to sql server is going to be dependent upon the platform keys that you have for Informatica. Having the driver and everything is fine, but finally informatica allows interaction to OS/databases based on the platform keys, these keys are normally purchased and have therefore price attached to every additional environemnt/database you want to access.

answer Apr 29, 2014 by Shweta Singh

Similar Questions

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)

+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 using Oracle database

We are bulkloading few of our target Oracle tables. Many of our tables had one column with datatype timestamp(6) with local time zone. when we insert just the date value(mm-dd-yyyy) then target database is defaulting the hh:mi:ss to 11:00:00 PM. But when we make the load type as normal then the it is inserting 12:00:00 AM in hh:mi:ss part. Could someone explain why this is happening?

Thanks in advance.

+1 vote

I want to Install a Neo4j server and input a simple database?

I want to Install a Neo4j server, and input a simple database that shows how you are related to 10 other of your family members. In there, add details such as name, age, job etc for your family?

Please help?

...