How to create an ODBC in Informatica
For creating an ODBC, we can follow two methods:
- Go to Control Panel => Administrative Tools =>Data Souces (ODBC)
- Select System DSN tab and click on Add
- Select the driver Oracle in OraDB10g_home
- Then click Finish.
- Enter the following details:
- Data Source Name: Source_Scott_ODBC (your choice)
- TNS Service name: ORCL
- User Id: Scott
- Then click on Test Connection
- There enter password and finally click on Ok.
Or you can also creating an ODBC from Informatica level as follows:
- While Creating the target, first we need impliment the metadata of the target by drag the source in
- Target Designer and then Generate/Execute SQL.
- Click on Connect then click on Add.
- Select System DSN tab and click on Add
- Select the driver Oracle in OraDB10g_home
- Then click Finish.
- Enter the following details:
- Data Source Name: Source_Scott_ODBC (your choice)
- TNS Service name: ORCL
- User Id: Scott
- Then click on Test Connection
- There enter password and finally click on Ok.
I am William..
ReplyDeleteI just browsing through some blogs and came across yours!
Excellent blog, good to see someone actually uses for quality posts.
Your site kept me on for a few minutes unlike the rest :)
Keep up the good work!Thanks for sharing a important information informatica
Please use correct grammer, else good.
ReplyDeletebro instead criticizing others. pls first check your spelling!!!
DeleteHow about 'grammar' instead of 'grammer'? I know British english and American english and yada yada.. but still if you want to complain, you can complain about anything. Don't be a grammar Nazi, if you understood him then that's enough. Peace
ReplyDeleteNice article.
ReplyDeletefor informatica interview questions and answers click here
This is very informative and this is very usefull to us.
ReplyDeleteInformatica online training , informatica training in bangalore
informatica online training , informatica training in bangalore , informatica training , informatica online trainig in bangalore
nice post
ReplyDeleteinformatica training , infromatica online training, informatica training in bangalore, infromatica online training in bangalore