Sharepoint, InfoPath and Oracle integration
We have a form set up with Sharepoint 2013 and InfoPath 2010. We also have Oracle 12..
What is the best way to automatically get the information into an Oracle table on a periodic basis (nightly) or to have the ability of Oracle to link to it?
The catch is we are in a corporate environment and do not have access to the Sharepoint server, SHarepoint Designer or Internet Information Services.
Jerry
What is the best way to automatically get the information into an Oracle table on a periodic basis (nightly) or to have the ability of Oracle to link to it?
The catch is we are in a corporate environment and do not have access to the Sharepoint server, SHarepoint Designer or Internet Information Services.
Jerry
ASKER
anyone else have a solution?
Going once, going twice.....
Going once, going twice.....
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
However, it may be possible to use the "form" you have set up. Is that a data entry form for this SharePoint data? Does all of the data you are interested in get entered through this form? Can that form be modified to include an ODBC connection to Oracle? If your answer is "yes" to all of these, then you should be able to at least capture the new data from now on. That won't help you get existing Sharepoint data into Oracle, but without access to the SharePoint server, I don't know of a way that you will be able to automate that anyway.