I’ve been successfully working with ProcessFlow for many years; arguably one of the best interface/processing tools I have ever used. Recently we have been trying to use the SQL Query node to grab data from other database systems (other than our Infor Lawson one). Once you get the correct “lock and key” set up between drivers, permissions, and server access it works great. Currently we have been using the SQL node with JDBC thin client for only Oracle databases. We now want to use the SQL node for SQL databases. I downloaded the correct SQL jar files and got this to work locally from my desktop. When we went to test this on our hosted development server, the only way to get it to work by “running from server” was to only have SQL jar files in the applicable server folder (had to remove the Oracle jar files. I was told by the hosting vendor that we had to choose either having Oracle or SQL JDBC, not both. The ProcessFlow server could only be configured to look at one or the other JDBC files. It works locally through ProcessFlow running both, but not at the server end.
So I’m asking the residential gurus…is this true? Can the ProcessFlow server only be configured for either SQL or Oracle JDBC and not both at the same time? We are using ProcessFlow Integrator 9.0.1 (with the Eclipse version designer) but will be taking the plunge to IPA first quarter 2016.
Not true.
I have created flows that access both MS-SQL & Oracle for the same client.
You will need to "override" the configuration at the SQL node to point to MS-SQL (or Oracle).
--
Your hosting vendor may be stating that you can only have 1 "overall" configuration.
In IPA 10 this has changed to allow multiple "overall" configurations.
jdever,
I'm using the "Overide JDBC" option for both my SQL and Oracle JDBC flows in ProcessFlow designer, but it still won't seem to work on the server side. It works great locally as I can connect and retrieve information from both databases, just not when it is "run from server" (either through ProcessFlow designer or through PF Administrator by manual trigger). Is there another "Override JDBC" option on the server side that you are referring to?
Make sure you have the proper JDBC jar files for both MS-SQL & Oracle in the $GENDIR/bpm/jar directory.
The ones I use locally work perfect, so I'll have to verify with the hosting company they are using the same ones. I'll contact them and have them install the ones that I'm using, retest, and update the post. Thank you for the advice.
I tested again and to no avail, I could not get this to work. Can you please let me how you are set up with your server settings that allows SQL JDBC to both SQL and Oracle databases? This way I can take any configuration information that you have and replicate the same set up for our hosted environment and hopefully get this to work.