1 of 2 people found this helpful
It will be same tool but you will not have access to QA and PROD for any
tools like Pentaho Dev studio etc.
2 of 2 people found this helpful
We're a Remedy On Demand (RoD) 8.1 user and have been for nearly 3 years now (looking to upgrade to 9 when not so busy).
We use Atrium Integrator/Pentaho Spoon a lot with RoD, but in order to connect it (on premise) to your RoD environment you'll need either a VPN connection or BMC's "Client Gateway" (installs as a Windows service, linux version may be available too) which is deployed on-prem in your DMZ and establishes a AR traffic tunnel to your DEV, QA and PROD environments over a HTTPS connection. You can then connect Pentaho (or Remedy DevStudio) to the relevant port (DEV/QA/PROD) on your gateway server and it works fine.
You can run Spoon jobs to push data up to RoD or pull data down, you can edit jobs (like DMT jobs) that run internally on Remedy, but what doesn't work for us is having Spoon jobs on your RoD server that will be run on a schedule on your RoD environment that need to talk to databases/servers on-prem to pull data into Remedy - maybe this can work if you have a VPN connection with Remedy but using the gateway I don't think it's possible. For us this does make it tricky to fully automate LDAP People data sync etc, but it is possible to work around, you just need to get used to pushing up your data into CMDB staging forms then having jobs that can take it onwards from there (I'm not a Remedy expert so maybe there's a better way - I did post a question about it but got little attention).
We extensively use the "Kitchen" command line version of Spoon to perform scheduled job runs on-prem to pull and push data from/to our RoD PROD environment - most crucially to pull ticket updates onto a local SQL database that we can then run reports from, but also to push CMDB and LDAP data up to Remedy.
For importing/exporting the Spoon tool is the same and imprt/export functionality is there, you'll be able to download it from BMC's EPD site (the enhanced CMDB version).