accel<>DS for Big Data

A versatile, no-code Data Integration tool integrates your Enterprise and offline data in minutes!



A versatile Data Integration tool to blend data from a variety of data sources (such as Oracle, HDFS, HIVE, SQL Server, Excel, XML, Text File, HTTP, Web Services) in minutes. Go beyond just Data Integration - clean, transform and prepare the data for analysis. Absolutely no coding required, ideal for business users.





Most data are generated and stored out of Hadoop, e.g. relational databases, plain files, etc. Therefore, data ingestion is the first step to utilize the power of Hadoop. Various utilities have been developed to move data into Hadoop..



The Data Integration tool is built from grounds up with performance and simplicity in mind. It utilizes the strength of the native databases transformation and processing power. In addition, accel<>DS is bundled with a native data transformation engine as well to provide high performance post integration transformations after data is brought in from different data sources.



accel-DS for Hadoop V1.0.9 is Now Available!.

Using accel-DS get the following data ingestion/transformation tasks done in minutes!



Data Ingestion

-

1. Database

  • Oracle
  • HIVE
  • SQL Server
  • MySQL
  • DB2
  • Informix
  • Terradata & any JDBC supported databases.


2. File sources

  • Delimited source files.
  • Fixed width source files


Data Transformation

-

Data transformation is the process of converting data or information from one format to another, usually from the format of a source system into the required format of a new destination system.


  • Type 0 - The passive method.
  • Type 1 - Overwriting the old value.
  • Type 2 - Creating a new additional record.
  • Type 3 - Adding a new column-(Pivoting the data)
  • Type 6 - Combine approaches of types 1,2,3 (1+2+3=6).

Script

accel ribbon1

Designer

accel ribbon2

Data

accel ribbon3

Formula

accel ribbon4

Data Integration made easy

-

accel product


accel<>DS (Data Store) makes Data Integration so easy and simple to use, in matter of minutes you are able to pull data from your enterprise systems, HDFS, Excel files, standalone Databases. The Data Integration module provides you with an easy to use, familiar spreadsheet interface to load data from a variety of data sources.

Versatile, Variety of Data Sources

-

The Data Integration module is versatile, allow you to integrate data from most of the popular databases such as Oracle, SQL Server, My SQL, Files such as Excel, Text, HTTP URLs, Oracle BI (OBIEE) and even SharePoint. This is pre-packaged with drivers for Oracle, SQL Server, DB2, MS Access etc.

No coding required

-

Data Integration tasks are predominantly drag and drop and it is ideal for users with no or very little programming background such as Sales Managers, Finance Managers, Business Analysts and power users in their team. Even better, as you build your integration tasks you are able to see as the data is built letting you visualize it.

Features

-

  • Build Data Stores / Data Warehouses integrating data from a variety of Data Sources.
  • Create Data Scripts to accomplish data integration tasks.
  • Use Workflow to assemble multiple scripts and execute them as a group.
  • Schedule and monitor Workflows to execute data integration tasks.
  • Familiar spreadsheet interface to load and see data in real time as data is integrated.
  • Built-in data transformation engine for optimal performance.

Benefits

-

  • Easy to use, business friendly tool.
  • Build Data Stores from a variety of data sources in matter of minutes
  • Maintain Data Stores with ability to refresh data periodically.
  • Visual, No coding required architecture make data integration easy.
  • The Data Integration tool is pre-packaged with popular drivers such as Oracle, SQL Server, DB2, making it easy to get it up and running in matter of minutes.
  • No coding required.


Hadoop Ecosystem with accel<>DS

-

Hadoop Ecosystem