Wednesday, November 7, 2012

Sterling Integrator - Database to XML Mapping

Here is the process for oracle and I am sure it's gonna be same for other databases as well,

1. Install Oracle Client Software. (Not Server).
2. Put database server entry in tnsnames.ora file.
3. Go to Control Panel where you installed Map editor create System DSN. When you click on
   Add you should see Oracle client there. (If you installed oracle client property)
4. Provide required database credentials and complete DNS creations.
5. Bring up your map editor create new map choose data format as SQL (Database
    Connectivity).
6. Go to Source Side properties in map editor go to Data Source tab select your DNS name and
    it will list all your tables and when you select table you can auto generate fields.

From here regular mapping. Be careful while editing tnsnames.ora.