Oracle to PostgreSQL.
Posted: Sun May 03, 2020 11:32 am
We are using Datastage 11.51 to copy tables over from Oracle 12G to PostgreSQL on GCP platform. IBM's ODBC driver is being used to connect to PostgreSQL.
[img]Oracle%20Connector%20---->%20ODBC%20/%20PostgreSQL[/img]
Table metadata is populated in Column definition tab. Unfortunately table creation is failing on all numeric columns.
ODBC_Connector_1: Error while generating the create table statement at run time. Could not obtain data type information from the ODBC driver for the column: ID. (CC_OdbcAdapter::generateCreateStatement, file CC_OdbcAdapter.cpp, line 1,069)
Can you please help?.
[img]Oracle%20Connector%20---->%20ODBC%20/%20PostgreSQL[/img]
Table metadata is populated in Column definition tab. Unfortunately table creation is failing on all numeric columns.
ODBC_Connector_1: Error while generating the create table statement at run time. Could not obtain data type information from the ODBC driver for the column: ID. (CC_OdbcAdapter::generateCreateStatement, file CC_OdbcAdapter.cpp, line 1,069)
Can you please help?.