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.

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

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

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

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

    SDF Screenshot 1

    FILE LAYOUT DEFINITION & CONTINUOUS LOADING WIZARD

    SDF Screenshot 2

  • WEB BROWSER-BASED DATABASE EXPLORER INTERFACE

    SDF Screenshot 3

    REMOTE GUI-BASED HOST UTILITY EXECUTION

    SDF Screenshot 4

  • CUSTOMISABLE CODE TEMPLATE-DRIVEN DEVELOPMENT

    SDF Screenshot 5

    PARAMETER SUBSTITUTION FOR TEMPLATE REUSABILITY

    SDF Screenshot 6

To download the brochure, click here or if you want more information, you can contact us here.