How to develop workflow to connect to Oracle database
Created: 20 Jan 2012 | 3 comments
Hi Gurus
I'm looking for a guide to use workflow to connect to Oracle Database.
Normally I create components with Integration one to connect MSSQL database, but the same way cannot be used with Oracle 10g database. I'm not sure if I did it wrong or it actually cannot be used with Oracle. (maybe the connection strings syntax are diffrent or something)
I try to find articles or discussions in forum that mentioned about this, but I couldn't find ones.
Could anybody please guide me the step-by-step how I can connect to Oracle database? Or if it used to have articles about this, please help guide me how to obtain them.
Thank you very much
Garr
Discussion Filed Under:
Comments
SQL compinents should be able
SQL compinents should be able to handle Oracle databases. What problem are you having?
The SQL components have the
The SQL components have the ability to connect to Oracle databases, you just need to have the Oracle Client on the machine making the connection. I believe you need to have version 8.x or better.
Rob
Hi Rob, reecardo Thanks a lot
Hi Rob, reecardo
Thanks a lot for recommendation. Previously I didn't install any Oracle components. I'll try Oracle client as mentioned.
Would you like to reply?
Login or Register to post your comment.