xFDN Home
Contributions
Bulk Upload to SQL server and Oracle
Author: Sheetal Dehadaraya, Software Labs Inc.
For accelerating your data loading activities xFusion supports bulk upload to SQL server and Oracle.
Some test performance numbers are -
*
Total time
includes Connecting to source , fetching source data, connecting to destination, creating destination table, uploading data
Source -> Destination
Number of Rows
Number of columns
Bulk upload
Total time
Upload time
SQL -> SQL
100000 (100K)
15
TRUE
16s
7s
SQL -> SQL
1000000 (1M)
15
TRUE
2m 25s
1m 14s
SQL -> SQL
100000 (100K)
15
FALSE
8m 0s
7m 49s
SQL -> Oracle
100000 (100K)
15
TRUE
34s
27s
SQL -> Oracle
1000000 (1M)
15
TRUE
4m 12s
3m
SQL -> Oracle
100000 (100K)
15
FALSE
5m 10s
4m 1s
Follow the following steps to enable bulk upload -
Bulk upload to SQL server
1. Create new export template.
2. Select
SQL Server® Data Connector
as destination connection from the databases tab.
3. Enter the connection information and click on Advanced Options.
4. Check the
Transactional (Bulk Insert)
option.
5. Make sure to choose the "Bulk Insert" option in the "Select update option" task. This option is available only if the user has checked the transactional option.
6. Complete the wizard to run the export.
Bulk upload to Oracle
1. Create new export template.
2. Select
Oracle® Data Connector
as destination connection from the databases tab.
3. Bulk Insert is only available through
Oracle ODP.NET Provider
. Select it from the drop down option.
4. By default the
Transactional (Bulk Insert)
option is checked. This option has to be checked.
5. Make sure to choose the "Bulk Insert" option in the "Select update option" task. This option is available only if the user has checked the transactional option.
6. Complete the wizard to run the export.
©2007 Software Labs, Inc.