Shred and import XML data into an Oracle database.
Exult Oracle is an easy-to-use Wizard Application which makes it trivial to import the data from one or more XML files into an Oracle database.
The following examples illustrate how Exult maps XML Elements and attributes to Database Tables and Columns.
|Example 1: XML View||Example 1: Database View|
|(Click for larger view)
(Click for larger view)
|Example 2: XML View||Example 2: Database View|
(Click for larger view)
1. Table CATEGORY:(Click for larger view)
2. Table SITE:(Click for larger view)
Exult Database Edition for Oracle works with all recent versions of Oracle including the following:
|Hardware||Pentinum III and later.||Operating System||
Windows Server 2008
Windows Server 2003
Access to an Oracle Database Server.
The Oracle database can be located on the local machine or on a remote server.
Click here to download the regular Oracle Client Libraries 11g for Microsoft Windows (32-bit). You should select the Oracle Database 11g Release 2 Client for download and accept the Oracle TechNet License Agreement. After downloading and installing the package, please make sure that ORACLE_HOME environment variable is set to the location where it was installed.
In addition, please also make sure that the environment variable TNS_ADMIN is set to the location of TNSNAMES.ORA which is typically found under $ORACLE_HOME/network/admin. This will enable you to use the Oracle instance names defined in TNSNAMES.ORA to be used as a connection string.
Instead of the full Oracle Client package, you can also install the Oracle Instant Client which contains just enough components to be able to connect to an Oracle Database. To install the Oracle Instant Client package, click here, accept the OTN License Agreement, download the package and unpack it in a suitable location on your system. You should then update the environment variable PATH to add this directory to your path.
Optionally you can also set TNS_ADMIN to point to where the TNSNAMES.ORA is located. Doing this will enable you to use instance names defined in TNSNAMES.ORA to be used as a connection string.
For more help, please check the Exult Oracle User Guide.
You can use the Exult Database Edition for Oracle in trial mode for 14 days. After the trial period is over, you will need to purchase a license to be able to continue using the software.
You are encouraged to complete the purchase of a license as soon as possible once you determine that Exult Database Edition for Oracle is suitable for you. You can always return it for a refund within 30 days if you are not satisfied.
Bug fix upgrades are free for the lifetime of the product. We won't ask you to pay again for an upgrade if you find a bug in the version you have purchased.
When you purchase the Exult Database Edition for Oracle, you won't be caught purchasing an older version when a newer version is around the corner. You get free upgrades to the latest version for upto 90 days from the date of your purchase.
Internet Explorer warning on Windows XP
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.