In the past we were able to use a Linked Server from our MS SQL database to a PostgreSQL DB. The DBAs had to install a special driver on our SQL Server before creating the link. From there we were able to build SQL Views and then View Forms or use via AIE.
In our case we were bringing back network device/configuration data from Netdisco into the CMDB. We found it was a little slow so we actually had SQL jobs that pulled all data from the relevant PostgreSQL tables into tables within our Remedy DB. Then we used the cached data for the CMDB jobs. Turns out it didn't take much longer to grab a whole table's worth of data and insert it into the Remedy DB than it did to grab a few records. Just doing some quick Googling I see pages that mention Pentaho and PostgreSQL together so it looks like you might able to use AI? Jason On Thu, Jun 11, 2015 at 6:12 AM, LJ LongWing <[email protected]> wrote: > ** > Well Croom, if I remember correctly is the last name of a gentlemen that > used to develop software for Remedy...this article > > http://ars-action-request-system.1.n7.nabble.com/OT-Croom-Consulting-td70571.html > seems to indicate that he decided to get out of the rat race some time ago > > So...your options include either writing your own in house, or finding > another vendor that'll write something for you because as I understand > it...BMC doesn't provide anything quite like that. > > On Thu, Jun 11, 2015 at 1:22 AM, MalviyaSaurabh < > [email protected]> wrote: > >> Thanks LJ. >> >> We have our custom based app on ARS 7.1 on solaris/sybase which has this >> croomardbccplugin.so (am not sure whether this was written in-house or >> downloaded from somewhere) which ensures connection and fetches detail >> using >> vendor forms based on vendor name : CROOM.ARDBC.POSTGRE with external >> PostGreSQL db. >> >> We have various workflows working on these forms. >> >> Now after having migrated application from 7.1 to 8.1 on linux/oracle, I >> am >> unable to find any similar plugin for ars 8.1 (for linux), I am intending >> to >> use the same vendor name : CROOM.ARDBC.POSTGRE. >> What shall I be doing to address this? >> >> Regards, >> Saurabh >> >> >> >> -- >> View this message in context: >> http://ars-action-request-system.1093659.n2.nabble.com/Does-remedy-8-1-have-or-support-a-Croom-PostgreSQL-plugin-tp7601596p7601616.html >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "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"
