SMART DATA FRAMEWORKS

WHY DO I NEED THIS?

If you need to:

!

• Migrate an existing PureData for Analytics (PDA)/Netezza, Snowflake, Redshift, Yellowbrick, Oracle, SQL Server, Teradata, MySQL, Greenplum, PostgreSQL, Google Big Table, or Db2 database to any of the above database types with just a few clicks
• keep a source and target system in
• reconcile and validate that migrated data matches source data
• automatically, regularly, and reliably load sequences of at least source data in the most performant way possible
• automatically generate custom extract,

HOW DOES IT WORK?

• automatically generate custom extract, load, and transform (ELT) and data quality detection logic
• run SQL scripts against any ODBC-compliant database from any device via a web browser
• a dedicated metadata database repository for storing control and log information
• customizable templates for performing data management tasks other than just loading, e.g., referential integrity checking; database housekeeping; etc.
• a portable GUI front end (that runs on Windows, OSX, Linux, and HTML 5 web clients) for configuring Framework metadata parameters and monitoring the status of executed code
• a command line interface for the scripting/scheduling/execution of Framework data management processes

THE RESULT?

• integrated Release Management for migrating code and database objects between different environments
• automatic email alerts when scheduled
• Developers and DBAs can focus on higher-value business user needs
• Takes the risk, cost, and time out of ‘Lift and Shift’ type migrations as well as ongoing data maintenance activities

FILE LAYOUT DEFINITION & CONTINUOUS LOADING WIZARD

CUSTOMIZABLE CODE TEMPLATE-DRIVEN DEVELOPMENT

PARAMETER SUBSTITUTION FOR TEMPLATE REUSABILITY

enquiries@smart-associates.biz

Yellowbrick is a registered trademark of Yellowbrick in the United States and/or other countries. Snowflake and The Data Sharehouse are registered trademarks of Snowflake in the United States and/or other countries.