Thanks - good to know. I finally got AI working. Little thanks to BMC support on that. I don't think I need this solution right now.
James On Wednesday, March 9, 2016 at 6:05:46 PM UTC-5, LJ LongWing wrote: > > ** > James, > A View form gives you all of the ability to query/update/insert/delete > that your account has permission to do on the other end, and is > significantly easier than setting up an ARDBC Plugin. > > On Wed, Mar 9, 2016 at 3:56 PM, jham36 <[email protected] <javascript:>> > wrote: > >> ** >> Thanks, but I need to update the data in the external database. I think >> I need a vendor form for this. >> >> My first solution to this was using AIE. That worked fine, but we are >> migrating to ARS 9.1 with AI and support is not very helpful in telling me >> how to pass a variable into my job/transformation into the ARInput step. >> They want me to directly query the AR database, which I am not a fan of >> doing since the table and column names may differ between dev and >> production. Going through the Application server with the ARInput step >> seems like a better solution instead of a TableInput step. >> >> On Wednesday, March 9, 2016 at 1:17:15 PM UTC-5, jham36 wrote: >>> >>> ARS 9.1 windows 2008 oracle 11 >>> External DB Oracle 11 >>> I am trying to use ojdbc6.jar file from the oracle client installation >>> to create a plugin to be used in a view form. >>> I am trying to follow the limited instructions that BMC offers on how to >>> do this, but everything is too generic. "create your plugin", "Add it to >>> the Plugin Server Configuration", "Add anything else you need" >>> That's not much help. I am sure someone has figured out how to do >>> this. I would think a connection to an external oracle database would be >>> fairly common. Common enough for BMC to provide better documentation. >>> >>> Can anyone point me in the right direction here? What needs to be >>> provided when using the Plugin Server Config form? What user defined >>> parameters are needed? What else is needed? Do I have to manually update >>> pluginserver cong and ar.cfg? >>> >>> Thanks, >>> James >>> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

