The Integration Pack for MSSQL Tasks
This IP provides extended Data Management functions to OIS and MSSQL.
This Integration Pack adds the following objects to Opalis Integration Server:
• Test MSSQL Connection
• Deploy MSSQL Scripts
• Get OIS Variable Info
• Update OIS Variable Value
• Generate XML from MSSQL
Take particular note of the "Get OIS Variable Info" and "Update OIS Variable Value", if implemented, these objects enable you to make those OIS Variables you have, actuall Variable! Oh, and if you wanted to be able to generate XML from a standard SQL table, check out "Generate XML from MSSQL" :)