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]> 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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
