Oracle Integration

[jordandakota]

Lots of legacy apps use Oracle as their source db. The source-mssql uses sqlcmd, source-oracle could use sqlplus which is available in the instant-client. MsSQLConnector uses pyodbc, OracleConnector could use cx_oracle or oracledb which may be preferred since its a light client and doesn't depend on the thick instant-client being installed.

Oracle has

• all_tables and all_views for the tables(self) method
• all_tab_columns for the columns(self) method
• all_constraints and all_cons_columns for the foreign_keys(self) method