Why Use SQR Integrator for your Data Warehouse

Why Use SQR Integrator for your Data Warehouse?

When contemplating a Data Warehouse, almost all companies go through a selection process. The selection process usually entails both a qualitative and quantitative analysis on subject such as cost, ease of use, speed, maintainability, and so on. When looking at the ETL Tool landscape, you may wish to consider using SQR Integrator, which has significant advantages for a large portion of the medium to large sized enterprise. If your enterprise already has PeopleSoft, ADP Payroll, or some other enterprise system that has SQR (Sequential Query Reportwriter) embedded in it, SQR Integrator can offer you real value for your IT budget.

SQR already in production

By virtue of the fact that SQR is a much more mature technology than most ETL tools, and due to the big Y2K “remediate or replace” that happened with ERP systems, the availability of SQR talent is much greater than other ETL tools. In some cases, implementation teams with dozens of SQR developers. The usual data warehouse implementation has only a few ETL developers at best.

Lower Training Costs

If you have resources that already know SQR, SQR Integrator training will be a breeze
for you current resource. SQR Integrator is repository based, with user generated
“commerce objects” that contain business logic. These commerce objects are visually
connected together in a mapping that allows the user to generate ETL scripts in SQR. A
resource who already knows the technical and functional aspects of SQR in a production
environment will generally be a quick study with this ETL tool. Once they create a
mapping, they will be able to see the results in SQR, which they readily understand.

Ease of use

The Graphical User Interface only requires mastery of 6 basic objects: Source, Target,
Filter, Join, Transform, and Database Strategy. Once your resources are familiar with the
basic objects, creating just about any SQR is a snap.

Ease of maintenance

Unlike using manually written SQR, SQR Integrator saves all business logic into a
repository. When changes have to be made to an ETL process, the user can easily
identify the commerce object that requires the change. Once the changes are made, the
user can save the mapping to the repository, and then generate the new ETL script that
reflects the changes. There is also a facility for impact analysis for proposed changes.

Use your existing platform

Your company may have an enterprise server that has an enterprise application and
database, such as PeopleSoft HR, Payroll, Financial, or maybe a standalone ADP payroll
application with SQR already installed. If that is the case, you already have all you need
to run SQR Integrator. Since the Application Interface is only accessing your database
for the purposes of building an ETL SQR, the only significant impact to your current
production system is the added burden of running more SQR programs.

Widely available resources

Since there are upwards of 25,000 ERP installations that use SQR, the SQR skill set is
widely available in most medium and large sized labor markets. Instead of using a brand
new tool set with the associated training and recruitment costs, use SQR Integrator, with
its large pool of trained SQR developers.

Platform Stability

SQR Integrator outputs ETL code in the SQR language. SQR is one of the fastest, most stable interface languages ever built. It is noted for its rock solid stability in the production arena.

SQR Integrator tunes the SQR to the database; other ETL tools require the database to be tuned for it.

In a perfect world, API based ETL tools would be able to tune their queries to the database. In practice for large processes, a developer needs to request that the DBA tune the indexes for the process. SQR Integrator will allow the developer to pick the already generated indexes from PeopleSoft and ADP systems.

This removes yet another step in the development cycle. There have been many complaints in the past that current mainstream ETL tool architectures have inherent weaknesses when using them against some enterprise applications, in particular, PeopleSoft, ADP, or other applications that have SQR embedded in them. This is due to the inability of some architecture to join more than twosources simultaneously, disallowing the use of some of the indexes already used with the source application.

SQR Integrator uses PowerJoin Technology tm to allow the simultaneous join of even a dozen tables. Some companies are even dropping back to hand coding SQR to get around using the ETL tools altogether. If this is a possible situation your company could get into, consider SQR Integrator. Implementation Science Resources have 50,000 + hours of implementation time that has gone into the planning and development of a tool that can make using SQR in an ETL environment much easier.

SQR Integrator is an object oriented, repository based ETL enterprise tool. Although SQR Integrator has a visual drag and drop development environment, it only uses the speed, stability and power of SQR to do the heavy lifting, instead of having to pump data through an API engine. There is no client or network based contention as in some of the current ETL offerings, especially when incorporating flat file sources into the mapping. SQR Integrator is fast, mpp capable, stable tool that was made specifically with the large data warehouse in need of speed in mind.

Write your comment