We specialize in developing high performance ETL and XML DB solutions for our clients. Our design philosophy leads us to encourage our clients to take advantage of the ETL tools that Oracle has added in 9i and 10g. When it comes to choosing an optimal solution, it is very important that the process designer have an extensive knowledge of the current technology and the options they provide.
It is common for decision makers to be inclined to use costly out-of-the-box software. Sometimes this can be the best decision but this can often be the wrong choice for the organization and their specific requirements. Our consultants can help you evaluate your organization specific requirements and determine the best options. We do not endorse or prefer any specific 3rd party vendor, so our analysis will be purely subjective.
The recent releases of Oracle have introduced tools that can greatly improve the efficiency of loading large volumes of data, even with complex transformations. If your database is Oracle 9i-10g, we encourage you to discuss a custom solution with us.
One of our most recent projects involved a large data integration that imported a very large external XML data set to an existing database. Our Oracle XMLDB powered solution efficiently shredded a set of data ranging in size from a few KB to 700MB single rooted XML files. Our solution was able to save our client several millions of dollars by providing an in-house instead of a vendor provided solution.
