How to Rename the ODBC Data source in Import tables->connect to database in informatica?

499 views

I want to know how to rename the ODBC data source in informatica.

posted Apr 15, 2014 by Pooja Bhanout

Share this question

Facebook Share Button

Twitter Share Button

LinkedIn Share Button

1 Answer

I can think of two approaches. One, create a new ODBC connection on your PC and use that connection to re-import the source. Two, edit the source and click on the rename button. The second field is the database name, and editing that field will cause your source to appear to have been imported using an ODBC connection with whatever name you place in that that field.

answer Apr 17, 2014 by Shweta Singh

Similar Questions

+2 votes

How to Rename the ODBC Data source in Import tables->connect to database in informatica?

I want to know how to rename the ODBC data source in informatica.

+1 vote

How to connect to a ODBC Data Source with SSL for my RoR App?

My Ruby on Rails App needs to connect to a ODBC Datasource that has SSL only enabled.

Can somebody give me an example of connecting to a ODBC Source with SSL?

I constantly get SSL required error. I don't see the option of passing SSL Certificates via UnixODBC. May be something I am missing.

+2 votes

Informatica: If Source Qualifier transformation populates two target tables, How to ensure TGT2 is loaded after TGT1?

Suppose we have a Source Qualifier transformation that populates two target tables. How do we ensure TGT2 is loaded after TGT1?

+1 vote

Import source definition in informatica

In Informatica, When I am trying to import a source definition from db (oracle data source) I get below error

[microsoft][odbc driver manager] the specified dsn contains an architecture mismatch between the driver and application

What I understood after doing some surfing is Informaitca is trying to access

C:\Windows\SysWOW64\odbcad32.exe

and not C:\Windows\system32\odbcad32.exe

When I try adding system/user data source (in C:\Windows\system32\odbcad32.exe), I am not able to see oracle.

Please help to get this issue resolved.

0 votes

Informatica: How to import data from 2 table(parent and child table)?

I tried the SQ and linked directly from source to SQ only the required columns and generated workflow but it shows no result. Do I have to use any other transformation or do I have to add query in SQ if so how? help me thanks in advance.

...