Can Infopath creates data connection to Oracle server?
G Greg Collins Mar 6, 2008 #2 InfoPath cannot directly connect to Oracle. However, a Web Service can be used in between to allow InfoPath to communicate with Oracle.
InfoPath cannot directly connect to Oracle. However, a Web Service can be used in between to allow InfoPath to communicate with Oracle.
C Clay Fox Mar 7, 2008 #3 Another option is to interface the data you need from Oracle to SQL and then use web services to query from SQL.
Another option is to interface the data you need from Oracle to SQL and then use web services to query from SQL.
B Batman Mar 7, 2008 #4 Thanks for your recommended option. It would be almost the same idea as to use export feature into excel format, and run SQLloader software to pass all the data back to our Oracle database. Correct me if I'm wrong.
Thanks for your recommended option. It would be almost the same idea as to use export feature into excel format, and run SQLloader software to pass all the data back to our Oracle database. Correct me if I'm wrong.
C Clay Fox Mar 7, 2008 #5 You want to submit back to Oracle? Then yes you would submit to SQL and then setup your interface and transaction handling per your requirements.
You want to submit back to Oracle? Then yes you would submit to SQL and then setup your interface and transaction handling per your requirements.