I've been tasked with updating remote MS SQL database tables. I'd like best ideas for utilizing our IBM i to do this. I'm primarily and ILE-RPG, RPG Freeform programmer, but have worked using RPG-XML (which we have) and consuming web services via a local MS SQL database. I'm also familiar with SQLLERPG to a degree.
I have access to 'data source', 'Initial Catalog', 'User ID', and 'password' for the remote database tables.
All ideas are welcome and will rewards points accordingly.