Oops … that should have been create a local database view in the ARSYSTEM schema pointing to the external database
Basically in the local ARS database do CREATE DATABASE LINK MY_DBLINK CONNECT TO external_db_user IDENTIFIED BY external_db_pass USING '(description= (address_list= (address= (protocol=tcp) (host=external_server) (port=1521))) (connect_data= (service_name= external_service_name)))'; Then in the local ARS database do CREATE OR REPLACE VIEW MY_LOCAL_VIEW AS Select * From external_table@MY_DBLINK; You can then create a View Form in ARS against MY_LOCAL_VIEW One advantage of using the local database view of the external is if you have multiple environments (Dev, Test, Prod, …) and you need to connect Dev to an external Dev, … the ARS form is exactly the same in each. Only the dbLink definition or local database view definition changes between environments. Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, March 09, 2016 1:34 PM To: [email protected] Subject: Re: Vendor Form to external Oracle Database ** Since you are on Oracle I would suggest just creating a dbLink to the external Oracle. You can then create a View form thru the dbLink (although I prefer to create a local database view in the ARSYSTEM schema of the external database and then create my View Form off of that) No Vendor plugin needed for a View form Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of jham36 Sent: Wednesday, March 09, 2016 12:17 PM To: [email protected]<mailto:[email protected]> Subject: Vendor Form to external Oracle Database ** 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"
