| Data Transformation Server offers a powerful middleware application to document, automate and execute critical data processes especially for creating and populating data marts from various internal or external data sources. This allows data to be received from multiple sources in different formats and mapped to a common database schema. This enterprise-class software allows companies to centrally manage their data schema and mapping rules in a central repository and directly archive those rules in PDF documents for easy sign-off. |
|
Adeptia designed and developed DTS
to focus on rapid implementations through its ease of use
and cost effectiveness for Extract, Transform, and Load
(ETL) type of scenarios. Product includes the following capabilities:
- Process Designer is a web-based design tool to help IT staff collaborate with business analysts (if needed) to easily create and document their data flows, routing rules and business processes in a highly graphical, intuitive way. The designed process can be exported to a PDF format document for sharing and archiving. Learn More...
- Data Mapper is another web-based, graphical design tool that makes it really easy to specify data conversion, validation and data cleansing rules to process the incoming data. Even very complex rules can be easily specified without writing any code. The Data Mapper supports Any-to-Any mapping, meaning transformation rules can be applied where sources and targets are in any different formats. This tool includes a library of functions which can be pre-created and reused again and again. Finally, the Data Mapper has a "preview" capability to see actual source and target data, while the rules are being specified, if the soruce data file is available. Learn More...
- Data Schemas and Transport capability is included to support processing of data in any format whether it is Text or CSV, XML, any Databases (such as Oracle, MySQL, SQL Server, DB2, Sybase), EDI, HIPAA, ACORD AL3, any Fixed-Length file format, or any other format. Any format can be a source or a Target in a data flow. Adeptia also supports all the data transport protocols to connect with various applications and systems. Learn More...
- Monitoring System and process flow monitoring feature offers a consolidated view of server resources, users logged in and all the processes that are currently running. Learn More...
- Custom Service Plug-in capability allows important extensibility in this solution because any existing external programs, in any programming language, can be plugged-in as a service in the Adeptia DTS and can be reused at any time in any data flows. This allows organizations to leverage existing work and move their existing interfaces into a "services-based" solution where everything can be centrally managed.
- High Performance is important when processing bulk data and Adeptia DTS is designed to easily handle very large data volumes in a robust, efficient and graceful manner. Learn More...
- Document and formalize data flows and mapping rules
- Enforce data validation rules by specifying them in processes
- Ensure data flows are constant and repetitive, not ad-hoc
- Trigger data flows based on real-time or scheduler events
- Specify error-handling rules and manage exceptions
- Leverage technology investments by extending functionality of existing systems
- Enhance customer and partner relationships by making it easier to do business with your organization
Adeptia DTS is a flexible software product that is an ideal platform to create many types of data connectivity solutions and address different types of integration needs. One of the common uses of the product is listed below.
- Extract, Transform and Load (ETL) for Business Intelligence (BI): Data analysis for business intelligence requires information to be aggregated from multiple sources into a data warehouse. Adeptia DTS has been used by many customers in an ETL scenario to collect data in different formats, using different protocols and then normalize the data into a target database for later analytics. Learn more...
- Data Conversion: Adeptia DTS is ideal for converting XML, Text or Excel files to a database. Mapper contains Math, String, and Conditional functions to convert data to any output format. This solution is also perfectly suited for database to database conversion. Learn more...