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 sync by periodically detecting and migrating deltas between the two
- reconcile and validate that migrated data matches source data
- automatically, regularly, and reliably load sequences of flat file source data in the most performant way possible
- 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
Smart Data Frameworks (SDF) improves developer productivity, quality, and consistency, whilst simultaneously reducing development, testing, and maintenance timescales, costs, and risk.
HOW DOES IT WORK?
Smart Data Frameworks consists of:
- a pre-configured virtual machine containing a number of pre-installed software components
- a dedicated metadata database repository for storing control and log information
- customisable 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
WHAT IS THE RESULT?
- Faster, cheaper, better data integration
- Shorter time to value
- 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
OTHER FEATURES
- Integrated Release Management for migrating code and database objects between different environments
- automatic email alerts when scheduled processes fail, for whatever reason
- native Teradata function and feature (e.g. SET tables, case insensitive character comparisons) compatibility
-
AUTOMATED DATABASE CONVERSION & MIGRATION WIZARD
-
FILE LAYOUT DEFINITION & CONTINUOUS LOADING WIZARD
-
WEB BROWSER-BASED DATABASE EXPLORER INTERFACE
-
REMOTE GUI-BASED HOST UTILITY EXECUTION
-
CUSTOMISABLE CODE TEMPLATE-DRIVEN DEVELOPMENT
-
PARAMETER SUBSTITUTION FOR TEMPLATE REUSABILITY
-
AUTOMATED DATABASE CONVERSION & MIGRATION WIZARD
-
FILE LAYOUT DEFINITION & CONTINUOUS LOADING WIZARD
-
WEB BROWSER-BASED DATABASE EXPLORER INTERFACE
-
REMOTE GUI-BASED HOST UTILITY EXECUTION
-
CUSTOMISABLE CODE TEMPLATE-DRIVEN DEVELOPMENT
-
PARAMETER SUBSTITUTION FOR TEMPLATE REUSABILITY