top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
589 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

0 votes

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

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

+1 vote

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

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

+1 vote

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

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.

...