Let Magenic show you how to streamline your Extraction, Transformation and Load (ETL) projects.
ETL is Everywhere
Data is the lifeblood of any business. Data is a tangible asset that every business owns. Data is also never static. Moving data is an ever-present task of any Enterprise. Whether it’s a one-time data load from a legacy system or a periodic load into a data warehouse or reporting database, Magenic understands that this task doesn’t have to be painful.
Magenic has developed a system of tools to successfully develop and manage your data movement requirements. The Foundation Data Transformation Accelerator™ (FDTA) allows the Developer to avoid the common pitfalls of ETL development. Development is reduced to a set of common templates. These templates, along with the FDTA Metadata Database, aid with issues akin to ETL platform promotion, error recognition/handling and batch execution success/failure. Development costs will be reduced, money will be saved in testing and post-production system monitoring will be shortened.
FDTA Benefits Abound
· Rapid Development
o Templated
o Infrastructure reduced to Copy/Paste.
· External Source for Configuration Variables and Workflow Management
o Accelerator Metadata Database
o FDTA Control Panel – a VB.NET Windows application allows easy editing and monitoring of the configuration variables, batch execution status and errors.
· Reentrant Capability Saves Development Time
o Developer easily controls workflows and execution paths.
o Accelerator tracks completed transforms with success or error. Successful transforms are never rerun when batches are restarted, saving time and costs.
· Environment Promotion
o Moving Transforms from development to QA to production is as easy as changing a configuration variable in the Metadata Database.
· Excellent for Analytical, Reporting or Transactional Systems
o Ideal for reoccurring or periodic transforms in OLAP or Reporting systems.
o Perfect for development of “one-time” legacy transactional data promotions.
· Error Trapping
o Errors are trapped and written to the Metadata Database. Eliminates hunting for error logs. Errors are viewed in the FDTA Control Panel application.
· Uses Microsoft Data Transformation Services
o Multiple Data formats supported including SQL Server, Access, Excel, Dbase, Text (Flat) Files, HTML, Paradox, Oracle or any other OLE DB data source.
· Open Source Code
· Focus Shifts to Business Process
o The infrastructure is in place allowing the developer to concentrate on the business rules.
Implementations
· Manufacturing
· Retail
· Financial Services