Migrating your Data Warehouse is a breeze using Smart Data Frameworks

Why do I need Smart Data Frameworks?

If you need to:

  • migrate an existing PureData for Analytics (PDA)/Netezza, Oracle, SQL Server, Teradata, Yellowbrick, 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 ODBCcompliant 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 Smart Data Frameworks work?

Smart Data Frameworks consists of:

  • SDF is a Flatpak application, using container technology similar to Docker, containing a number of pre-installed software components
  • a dedicated metadata database repository for storing control and log information

Smart Data Frameworks Key Highlights

  • 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
  • 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 of Smart Data Frameworks

  • 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

For further information about Smart Data Frameworks contact us. To download a brochure, click here.