Since business needs and decision support data requirements are constantly evolving, IT groups need to be able to quickly accommodate requests for new (usually urgent) data requirements. This means building new interfaces and changing existing interfaces in a timely fashion.

As the Data Warehouse grows it becomes increasingly difficult and cost prohibitive to continuously re-invent the wheel with custom coding, since custom coding is time consuming and requires the use of highly skilled and scarce developers. Fortunately, you don't have to! At a fraction of the anticipated cost, you could be using a state-of-the-art ETL tool that simplifies, expedites and self-documents every aspect of data migration.

Features

---

• Expedite the development and maintenance of interfaces
• Standardize all interface development tasks
• Perform address correction using Canada Post and US Postal Service certified routines
• Perform any required input file pre-processing (including delta generation, file splitting and file joining)
• Define all filtering criteria, data mapping and transformation rules
• Define exception handling and invoke event-triggered programs
• Email-notify key users upon completion of key interfaces
• View input/output data, resultant log files and run statistics online
• Debug and tune interfaces as required
• Group and schedule all interfaces and jobs
• Generate Meta Data Web reports (documentation)
• The SQL Power Loader instruction sets are defined through a set of user-friendly screens, eliminating the need to write any custom code for most interfaces. This not only reduces the time and cost associated with the traditional development lifecycle, but more importantly it places the tool in the designers' hands. Business analysts, system analysts and data architects are equally qualified to develop even the more complicated interfaces.
• Whether you're building a Data Warehouse, Data Mart, CRM or a Performance Management System, the SQL Power Loader will help automate, expedite, bullet-proof and self-document your data migration effort.
• The SQL Power Loader raises the bar on other ETL tools as it is extremely affordable, very easy to use and is guaranteed to yield a quick ROI - usually within 3 months of implementation.

---

Automated Data Migration with Guaranteed Quick ROI.

For more information on the SQL Power Loader or to arrange for an on-line demo, contact us at info@sqlpower.ca or call 1‑866‑SQL‑POWR.

Get Started

View Screenshots