With XML becoming the widespread language for communication between and within enterprises, building complex XML documents from databases has become an important requirement. Surprisingly, however, this is a difficult and complicated process. The code that must be written to retrieve data from a database and build XML structures is rather complex. Even for a document of moderate complexity, it takes multiple queries to obtain the proper results from a database. Once data is retrieved using these multiple queries, it must then be assembled into a correct XML document that conforms to a specific schema. This hand-coded approach results in solutions that are expensive to develop, difficult to maintain, and often have reliability and performance issues.
Centerprise Data Integrator brings a smarter approach to this problem by combining its highly sophisticated query and data mapping engines to offer a solution that eliminates the complexities associated with a hand-coded solution while offering superior performance, reliability, and maintainability.
Building complex XML documents from database is remarkably easy. Simply drag-and-drop source fields onto destination. For more complex transformations, use lookups, expressions, or other built-in transformations. This is all it takes to create XML documents from database. All the complexities of building SQL queries and retrieving data are handled by Centerprise query engine .
How Centerprise does it?
Centerprise uses a relational data model as a driver for building queries with multiple joins. If your database has the correct foreign keys defined, Centerprise will automatically build the data model and present your database structure in a tree structure during the mapping process. If, however, relationships are not defined in the database, you can use the Database Reverse Engineering capability of Centerprise to quickly create a data model and specify the relationships contained within. Once your data model is complete, you can use it to build queries .
Power of Data Mapping
Centerprise Data Mapping enables you to build complex data conversion jobs. A simple drag-and-drop interface enables you to do direct mapping. More complex maps can be developed by using lookups, expressions, SQL commands, and other mapping patterns. Single click source and destination previews instantly show the results of your data mappings. Key data mapping features include:
- Simple drag-and-drop mapping interface
- Single-click preview of individual and aggregate level data
- Full complement of mapping patterns including direct maps, constant values, expressions, built-in and custom functions, lookups, and SQL commands
Centerprise Transformation Engine
The Centerprise Transformation Engine is designed from the ground up to be a multithreaded parallel processing component that harnesses the power of today’s multi-core systems by processing tasks in parallel. Doubling the number of CPUs or cores on a machine usually doubles the throughput. Parallelism is used extensively throughout the engine including file reads and writes, database writes, and transformation. The engine is designed to efficiently process very large data sets.
Data Profiling
Data profiling is built right into the Centerprise transformation engine. You can obtain a detailed profile of your data as part of your transfer process or just run the profiler. The profile provides valuable record and field level statistics including minimum, maximum, average, sum, count, minimum length, maximum length, unique count and percentage, distinct count and percentage, duplicate count and percentage, etc.
Free Trial with Customer Support
Astera offers a free product trial of Centerprise. Additionally, you have access to our acclaimed customer support during the trial period. To start your free trial, send an email to
sales@astera.com or call
1-888-77-ASTERA.