The The SeETL RunTime RunTime SeETL Utilities Presentation Utilities Presentation www.InstantBI.com www.InstantBI.com 1/1/2012 1/1/2012
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. The Batch Maintenance Utility 2. The Batch Maintenance Utility 3. The SQL Statement Processor Utility. 3. The SQL Statement Processor Utility. 4. 4. The SQL Server 2000 DDL Generator Utility. The SQL Server 2000 DDL Generator Utility. 5. The Oracle 9 DDL Generator Utility. 5. The Oracle 9 DDL Generator Utility. 6. The Delimiter Separate Values Reformat Utility. 6. The Delimiter Separate Values Reformat Utility. 7. The Fixed File Format Reformat Utility. 7. The Fixed File Format Reformat Utility. 8. The Generate Delta File Utility. 8. The Generate Delta File Utility. 9. 9. The Batch Processing Scheduling Utility. The Batch Processing Scheduling Utility. 10. The The Process Group Manager Process Group Manager Utility. Utility. 10. 11. The The DataStage DataStage Job Submission Utility. Job Submission Utility. 11. 12. The 12. The DataStage DataStage Job Submission Utility Job Submission Utility – – With Parameters. With Parameters. 13. Load Dimension Tables into Memory Maps Utility. Load Dimension Tables into Memory Maps Utility. 13. 14. MetaData MetaData Checking Utility. Checking Utility. 14. 15. MetaData MetaData Printing Utility. Printing Utility. 15. 16. MetaData MetaData Loading Utility. Loading Utility. 16.
What Utilities are Available? � The The current suite are as follows: current suite are as follows: � 17. Correct and Reformat Data Utility. Correct and Reformat Data Utility. 17. 18. Sleep for BatchSleepSeconds Utility. 18. Sleep for BatchSleepSeconds Utility. 19. Reformat simple XML Documents Utility. 19. Reformat simple XML Documents Utility. 20. Delete specific rows Utility. Delete specific rows Utility. 20. 21. Perform Bulk Load on SQL Server Utility. Perform Bulk Load on SQL Server Utility. 21. 22. Start a Process in the Schedule from the DOS Box. 22. Start a Process in the Schedule from the DOS Box. 23. High Availablility Batch Processing Scheduling Utility High Availablility Batch Processing Scheduling Utility 23. 24. Execute SQL read from inside Database Utility Execute SQL read from inside Database Utility 24.
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 job submission utilities were all developed job submission utilities were all developed datastage 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 SeETL SeETL Runtime. Runtime. supported by � 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 Easysoft Easysoft for Oracle) for Oracle) � Oracle 9+ (using � 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 SeETL SeETL User Guide) User Guide) � Extensive User Guide (Part of � 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!
Recommend
More recommend