ODBC Importer

[Thomas Stuefer]

ODBC importer is a very nice tool !

But is it possible to import the data into a NEW oracle-table ? Or in other words: Before import of the ODBC-data creating a table with same fieldnames and data-types as the ODBC-source ?

 

[Marco Kalter]

You can press the "Create table" button on the ODBC Importer toolbar to create a table based on the ODBC datasource column names.

 

[gad]

Hello,
I tried the "create table" button.
Is it possible to fill in the types for thr table columns?

TIA

 

[Marco van der Linden]

After you press "create table" the edit table window appears. Navigate to the "columns" tab, there you'll find 'Type' as the second column. Here you can set the datatype for the column.

 

[gad]

I saw that of course.
But it's realy exhausting to fill in 50 types with length.
Is it possible to take the original types maped properly to oracle types (or string if not mapable)?

 

[Marco Kalter]

We hope to have this available in the next patch release.

 

[gad]

Great! Thanks.