The The SeETL RunTime RunTime SeETL Utilities Presentation - - PowerPoint PPT Presentation

The The SeETL SeETL RunTime RunTime

Utilities Presentation Utilities Presentation

1/1/2012 1/1/2012

www.InstantBI.com www.InstantBI.com

Introduction

• Why Have Data Warehousing Utilities?

Why Have Data Warehousing Utilities?

• What Utilities are available?

What Utilities are available?

• How are the Utilities developed?

How are the Utilities developed?

• What platforms are supported?

What platforms are supported?

• What support is available for free?

What support is available for free?

• Summary

Summary

Why Have DW Utilities?

• Many tasks on BI projects are the same across

Many tasks on BI projects are the same across projects projects

• Utilities make these same tasks faster,

Utilities make these same tasks faster, cheaper, more reliable cheaper, more reliable

• Utilities save time, effort any money while

Utilities save time, effort any money while also reducing risk also reducing risk

• Beware BI consultants who do not have a ‘kit

Beware BI consultants who do not have a ‘kit bag’ of utilities. These are ‘tools of the trade’ bag’ of utilities. These are ‘tools of the trade’

What Utilities are Available?

• The

The current suite are as follows: current suite are as follows:

1. 1. The Data Transfer Utility. The Data Transfer Utility. 2. 2. The Batch Maintenance Utility The Batch Maintenance Utility 3. 3. The SQL Statement Processor Utility. The SQL Statement Processor Utility. 4. 4. The SQL Server 2000 DDL Generator Utility. The SQL Server 2000 DDL Generator Utility. 5. 5. The Oracle 9 DDL Generator Utility. The Oracle 9 DDL Generator Utility. 6. 6. The Delimiter Separate Values Reformat Utility. The Delimiter Separate Values Reformat Utility. 7. 7. The Fixed File Format Reformat Utility. The Fixed File Format Reformat Utility. 8. 8. The Generate Delta File Utility. The Generate Delta File Utility. 9. 9. The Batch Processing Scheduling Utility. The Batch Processing Scheduling Utility. 10.

• 10. The

The Process Group Manager Process Group Manager Utility. Utility. 11.

• 11. The

The DataStage DataStage Job Submission Utility. Job Submission Utility. 12.

• 12. The

The DataStage DataStage Job Submission Utility Job Submission Utility – – With Parameters. With Parameters. 13.

• 13. Load Dimension Tables into Memory Maps Utility.

Load Dimension Tables into Memory Maps Utility. 14.

• 14. MetaData

MetaData Checking Utility. Checking Utility. 15.

• 15. MetaData

MetaData Printing Utility. Printing Utility. 16.

• 16. MetaData

MetaData Loading Utility. Loading Utility.

What Utilities are Available?

• The

The current suite are as follows: current suite are as follows:

17.

• 17. Correct and Reformat Data Utility.

Correct and Reformat Data Utility. 18.

• 18. Sleep for BatchSleepSeconds Utility.

Sleep for BatchSleepSeconds Utility. 19.

• 19. Reformat simple XML Documents Utility.

Reformat simple XML Documents Utility. 20.

• 20. Delete specific rows Utility.

Delete specific rows Utility. 21.

• 21. Perform Bulk Load on SQL Server Utility.

Perform Bulk Load on SQL Server Utility. 22.

• 22. Start a Process in the Schedule from the DOS Box.

Start a Process in the Schedule from the DOS Box. 23.

• 23. High Availablility Batch Processing Scheduling Utility

High Availablility Batch Processing Scheduling Utility 24.

• 24. Execute SQL read from inside Database Utility

Execute SQL read from inside Database Utility

How are Utilities Developed?

• Directly from experience

Directly from experience

• Many of them were developed over the years from

Many of them were developed over the years from direct need on project work direct need on project work

• From direct customer requests

From direct customer requests

• The delta generation utility, scheduler and

The delta generation utility, scheduler and datastage datastage job submission utilities were all developed job submission utilities were all developed from direct requests from IBI clients from direct requests from IBI clients

• If you want more utilities developed contact us

If you want more utilities developed contact us

• We may have other clients who want the same thing

We may have other clients who want the same thing

• Increasing value of utilities increases value to all IBI

Increasing value of utilities increases value to all IBI clients clients

What Platforms are Supported?

• The

The SeETL SeETL Utilities run on all platforms Utilities run on all platforms supported by supported by SeETL SeETL Runtime. Runtime.

• Currently these are:

Currently these are:

• Win2000+

Win2000+

• Oracle9+, SQL Server 2000+, Sybase ASE 12+, Sybase IQ12+,

Oracle9+, SQL Server 2000+, Sybase ASE 12+, Sybase IQ12+, DB2UDB 8+ DB2UDB 8+

• AIX 5.1+ (64 bit), Solaris 9.0+ (64 bit)

AIX 5.1+ (64 bit), Solaris 9.0+ (64 bit)

• Oracle 9+ (using

Oracle 9+ (using Easysoft Easysoft for Oracle) for Oracle)

• Sybase IQ 12+

Sybase IQ 12+

What Free Support is Available?

• The Utilities are only free on win2000+

The Utilities are only free on win2000+

• Support includes

Support includes

• Extensive User Guide (Part of

Extensive User Guide (Part of SeETL SeETL User Guide) User Guide)

• Downloadable source code for programs

Downloadable source code for programs

• Classes are not available to download

Classes are not available to download

• Active User Groups on our web site

Active User Groups on our web site

• For AIX/Solaris/Linux support the

For AIX/Solaris/Linux support the SeETL SeETL must must be licensed as the source code must be be licensed as the source code must be provided provided

Summary

• Why Have Data Warehousing Utilities?

Why Have Data Warehousing Utilities?

• What Utilities are available?

What Utilities are available?

• How are the Utilities developed?

How are the Utilities developed?

• What platforms are supported?

What platforms are supported?

• What support is available for free?

What support is available for free?

• Summary

Summary

Thank You for Your Time!