Follow Datanami:
March 28, 2016

Impetus Technologies Launches New Data Warehouse Transformation Practice

LOS GATOS, Calif., March 28 — Impetus Technologies, a software products and services company, today announced the formation of a new data warehouse transformation practice. The practice is comprised of an innovative automation migration toolkit, as well as methodologies and services, that allow enterprises to rapidly migrate their data warehouses while preserving their investment in current implementations. As a result, Impetus Technologies can save enterprises millions of dollars annually by enabling them to cost-effectively and efficiently Workload Migration solution to help enterprises identify and safely migrate data, extract, transform, and load (ETL) processing and large scale analytics from the EDW to a big data warehouse (BDW). In addition, the company will offer a new

Software Automation Tools

Impetus Technologies’ engineers have been at work for many years perfecting a migration toolkit that can assess and migrate data and complex SQL-based applications, thereby preserving years of investment by an enterprise. The toolkit comprises:

  • Workload Migration – A comprehensive automation toolset to automate the conversion of existing SQL-based scripts into equivalent HiveQL or SparkSQL for optimized execution in the Hadoop environment. Pre-built conversion logic is provided for Amazon Redshift, IBM (DB2, BLU Acceleration and Netezza), Oracle, Microsoft SQL Server and Teradata source data stores. Similar capabilities are underway for addressing SAP Hana workloads. Included are built-in assessment functions for offloads with intuitive workflow, enhanced features for quality checking during data migration, and tiered intelligent offloading with Apache Hbase, Apache Hive, Apache Phoenix, Apache Spark, Java and Scala. Additionally, it includes a library of advanced data science machine learning algorithms for solving difficult data quality challenges.
  • Data Blending – The only end-to-end, self-service tool based on open source technology in Hadoop, it provides a simple, easy-to-use interface to quickly connect multiple data sources allowing users to effortlessly blend data. It also provides an automated mechanism to build different datasets through blended data pipelines allowing users a four step process – connect, blend, publish and consume. This process accelerates offloading time and cost savings, delivers faster parallel and SQL processing using Hadoop along with streaming ETL options, maximizes existing SQL and stored procedure investments and reuse of tools. This reduces Hadoop migration project risk through the use of proven best practices and automated quality assurance checks for data and logic.

Modernization Services

Impetus Technologies’ experts utilize a structured, repeatable methodology to deliver a customizable range of services from assessment and planning, through implementation and data quality validation.

  • Assessment and planning – analyzes current EDW workloads and processing to identify high priority migration candidates. The output from this activity is a realistic blueprint and road map that includes a calculation of the expected ROI. These outputs are then used to define and guide the automated migration process.
  • Implementation and data quality validation – various resource options are available, ranging from the use of Impetus Technologies’ experts to perform the work, establishing a migration factory, guiding and augmenting internal teams, or some combination.

Impetus Technologies will be demonstrating the capabilities and benefits of its data warehouse transformation offerings at Strata + Hadoop World conference, March 29-31, 2016, in San Jose, California at booth number 822. Members of the media and analyst communities interested in booking a meeting with the company should contact [email protected].

About Impetus Technologies 

Impetus Technologies is focused on creating big business impact through big data solutions for Fortune 1000 enterprises. The company offers a unique mix of software products, consulting services, data science capabilities and technology expertise. It offers full life-cycle services for big data technology implementations, including technology strategy, solution architecture, proof of concept, production implementation and on-going support to its clients. To learn more, visit: www.impetus.com.

Source: Impetus Technologies

Datanami