dbXpert for OracleFeatures Review
dbImport - Import Records from other data sources
The following steps show you how to do data import. dbImport allows you to import data from any ODBC data source into an Oracle table such as CSV, EXCEL, MS Access, SQL Server, DB2, Oracle, etc.
On the first page of the dbImport, you need to select the ODBC data source and then login to the data soruce if necessary.
Then, you need to select a table or enter a query text. After entering the source specifications, you can click the Preview button to view the records from the data source.
Select a target table and then click the next button
You needs to map the columns from the data source to the column of the tarage table. dbImport supports Oracle row function when doing data import. You can specify the function with the bind variables in the "Function" column. If the target column is not used, you can uncheck the checkbox on the left. The following example shows a mapping example:
1. ENAME <= SUBSTRING(:ENAME,1,3), where :ENAME represents the bind variable from the ENAME column of the data source.
2. MGR <= a constant 7000 is assigned for every record to be imported.
3. COMM is not mapped, that means it follows the default column values in the target table.
4. DEPTNO <= a constant 20 is assigned for every record to be imported.
If the column name of the data source follows the name of the target table, you can click the "Map by Name" button to automatically map the source columns and target columns by the their column name. By default, dbImport will map the column by the order of the column of the data source.
After you have specified the mapping, you can click the "Show SQL" button to view the import SQL text. If the mapping is ok, you can then click the next button to specify the import options.
You can specify the following options in the data import
a). Auto Commit
If this option is checked, dbImport will not allow you to rollback the data import.
If this option is un-checked, dbImport will ask you to commit or rollback the import at the end of the data import.
b) Show Error Records
If this option is checked, dbImport will show the source records in the output log if the records cannot be imported to the target table. Otherwise, dbImport will only show the ORA error messages.
c) Delete Records from the target table
You can choose to delete all records from the target table before importing data. You can choose either truncate the table or delete records.
d) Run Immediately
You must check the Run Immediately checkbox before you can click the next button. Once you click the next button in this screen, dbImport will start the import operation.
In the Data Import screen, dbImport will write all the error messages to the text box for your reference. You can click the "Save Log" button to save the log for future reference. In case you want to abort the import operation, just click the stop button on the right bottm of the screen.
If you found any error during data import and want to correct it, you can click the Stop button and then click the Back button to correct the mapping or import options. After you have updated the settings, you can click the next button to start the import again.
If the import is success, you can click the New button to start a new import operation.