Skip to main content
Question

ODB tool to generate DDLs

  • May 4, 2020
  • 1 reply
  • 10 views

satheesmohan

Hi team,
In one of the sessions in Vertica BDC2020 (The Shortest Path to Vertica – Best Practices for Data Warehouse Migration and ETL), it is mentioned about a tool odb to generate DDLs for migrating table structure from other databases. I am not able to get any help documents for this. Can somebody please help on this?

1 reply

marcothesane
Forum|alt.badge.img+1
  • Participating Frequently
  • May 4, 2020

For our internal dist list,

odb is much more than just a ddl generator. It's a query driver we at EMEA use for our PoC-s , it's a powerful data mover from database to database, by Google for example, and much more.
We have it incorporated in the odbcstack.tar.gz tarball - which has very much become the survival kit for the EMEA presales, for example, and Maurizio Felici (I forget his user name in this forum ...) , its author, will always have something newer than the rest of us, and could add to this.
Get the odbc stack tarball here:
https://microfocusinternational.sharepoint.com/:u:/t/BDPEmpowermentPortal/presales/EcgGAdq6C9pIgMScYeQ01ZYBM8Kx63N0cTVi8EHndAUp9Q?e=wjYYTx
You'll find the docu - odb_HOWTO_1.0.1.pdf, in that tarball, too.

happy playing ....