export data to MySQL

Connectivity

export data to MySQL

I am trying to import into MySQL with the MySQL Workbench migration wizard.

I can connect to source DBMS (Teradata), I can retrieve schema list from source, but I can't reverse engineer schemata.

Can someone let me know if this should be possible, or if I should rather use a tool like Kettle

I'm on Windows2008r2

ODBC driver 14.10.00.00

Workbench 6.0

Traceback (most recent call last):

  File "C:\mySQL\MySQL Workbench CE 6.0.7\modules\db_generic_re_grt.py", line 724, in reverseEngineer

    return GenericReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)

  File "C:\mySQL\MySQL Workbench CE 6.0.7\modules\db_generic_re_grt.py", line 228, in reverseEngineer

    catalog = cls.reverseEngineerCatalog(connection, catalog_name)

  File "C:\mySQL\MySQL Workbench CE 6.0.7\modules\db_generic_re_grt.py", line 381, in reverseEngineerCatalog

    schemata_names = cls.getSchemaNames(connection, catalog_name) or ['']

  File "C:\mySQL\MySQL Workbench CE 6.0.7\modules\db_generic_re_grt.py", line 191, in getSchemaNames

    return list(set(row[1] for row in cls.get_connection(connection).cursor().tables(catalog=catalog_name)))

pyodbc.Error: ('HYC00', '[HYC00] [Teradata][ODBC Teradata Driver] Catalogs Not Supported (0) (SQLTables)')

Traceback (most recent call last):

  File "C:\mySQL\MySQL Workbench CE 6.0.7\workbench\wizard_progress_page_widget.py", line 192, in thread_work

    self.func()

  File "C:\mySQL\MySQL Workbench CE 6.0.7\modules\migration_schema_selection.py", line 160, in task_reveng

    self.main.plan.migrationSource.reverseEngineer()

  File "C:\mySQL\MySQL Workbench CE 6.0.7\modules\migration.py", line 335, in reverseEngineer

    self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)

SystemError: Error("('HYC00', '[HYC00] [Teradata][ODBC Teradata Driver] Catalogs Not Supported (0) (SQLTables)')"): error calling Python module function DbGenericRE.reverseEngineer

ERROR: Reverse engineer selected schemata: Error("('HYC00', '[HYC00] [Teradata][ODBC Teradata Driver] Catalogs Not Supported (0) (SQLTables)')"): error calling Python module function DbGenericRE.reverseEngineer

Failed

1 REPLY
Enthusiast

Re: export data to MySQL

were you able to solve this?