Skip to Content
Technical Articles
Author's profile photo Rob Verschoor

Set your databases free! — with SAP Advanced SQL Migration

Assigned tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mister Makmerphy
      Mister Makmerphy

      So, we have BODS / BODS Workbench which is pure ETL, also brilliant Sybase Replication services (I'm big fan of these 2) and now Exodus?

      On what level does Exodus differ from these two and why do we need extra tool for that?

      IMHO in SAP this 'multiple tool' approach is a huge problem - there are so many reporting tools: WebI, Crystal, Exporer etc and now SAP is starting to do the same with EIM world.

      Author's profile photo Rob Verschoor
      Rob Verschoor
      Blog Post Author

      The different tools you mention are orthogonal and have different aims.

       

      ETL, Replication Server etc. are data movement tools, which can be used for *data* migration (which is just one phase, and a relatively simple one, in a migration process).

       

      In contrast, Exodus is a tool to help migrate SQL code (i.e. stored procedures) from a non-SAP SQL dialect to a SAP SQL dialect, especially for migrating custom (non-SAP) OLTP applications. So far SAP did not provide any migration tools that could do this.

      At the same time, Exodus does not do anything for data migration.

       

      Another difference is that Data Services and RepServer are actually SAP products that customer can buy. Exodus is a tool that is available to SAP Partners under a license agreement at no cost.

      Author's profile photo Former Member
      Former Member

      It's nice to see your post again after quite a long while, excellent stuff.

      There is almost no marketing push for SAP ASE, I hope SAP can shed some light on ASE.

      Author's profile photo Eduardo Alarcon
      Eduardo Alarcon

      I think this is a very clever investment in SAP ASE and being free would push customers and partners towards pure SAP landscapes.

      I'm not sure if many customers will migrate but this tool is something SAP had to do.

      Author's profile photo Rob Verschoor
      Rob Verschoor
      Blog Post Author

      Note that Exodus is not specific for SAP ASE alone, it also supports SAP IQ and SAP SQL Anywhere as target databases. But since the main target of Exodus is transactional stored procedures-based custom applications, ASE is indeed a likely target to be used.

      Author's profile photo Former Member
      Former Member

      Exodus can help to migrate SQL Anywhere to SAP Adaptive Server? i hope so ..

      Author's profile photo Rob Verschoor
      Rob Verschoor
      Blog Post Author

      No: Exodus does not currently support SQL Anywhere as a source DBMS.

      Author's profile photo Jaime Caballero
      Jaime Caballero

      Can i use exodus to change a postgres dump to be hable to load it into sap iq?

      Author's profile photo Rob Verschoor
      Rob Verschoor
      Blog Post Author

      No: Exodus does not currently support PostgreSQL as a source DBMS.

      Author's profile photo Manikandan T R
      Manikandan T R

      Can i use Exodus to convert from Oracle to SAP HANA?