Can SEQUEL Data Warehouse Handle Complex ETL Requirements?

 

We are confident the answer is yes.

Every organization has a unique set of ETL requirements. Over the last decade and more we've seen them all, and continually added functionality to Sequel Data Warehouse  to support everything we've come across. We are confident that Sequel Data Warehouse  will be up to the task for you. Listed below are some of the common requirements that Sequel Data Warehouse  supports -  but this is not an exhaustive list, so if we haven't listed your specific needs, it does not necessarily mean that Sequel Data Warehouse  doesn't have that capability.

• Real time or batch ETL
• Change Data Capture from journal images, both local and remote
• Access data from remote LPARS and non-IBM platforms
• Support for Big Data sources such as Hive and Impala
• Text, delimited and XML files as data sources
• Support for Cloud-based sources such as Salesforce
• Conditional joins
• Support for partial and closest match joins
• Join multiple rows from the same table
• Conditional business rules
• Derived columns
• Automatic casting of data types
• Legacy date conversions and date calculations
• Build and manage data  warehouse and data mart tables, views and indexes with no coding necessary
• Easily define and load trend tables
• Incremental load of summary tables
• Load multiple tables in one ETL process (inserts and updates)
• Generate Surrogate Keys
• Automated Support for Slowly Changing Dimensions
• Extensive error handling
• Reprocess errors (after correction)
• Audit reports and inquiries
• Reusable components
• User exits
• User defined Functions
• Simple integration with other processes
• Extensive security layer
• Provide extensive documentation via metadata layer
• Impact analysis tools
• Change Management and Versioning
• Extensive metadata reports
• Visual development environment
• Integration with DB2 Web Query
• Export metadata to other tools via XMI specification
• Reverse engineering (1 table, or entire database)
• Excellent load performance  
• Parallel loading on multi-CPU systems
• Push data to other platforms, either batch or real-time
• Data models
• Enforced data integrity

Didn't see what you were looking for, or need further clarification? Contact us and we'll let you know how we support your needs.