accel<>Data Store

Data Consolidation Tool

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

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



Data Consolidation made easy

-



accel<>DS (Data Store) makes Data Consolidation so easy and simple to use, in matter of minutes you are able to pull data from your enterprise systems, Excel files, standalone Databases. The Data Consolidation 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 Consolidation 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 Consolidation 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 consolidation 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 consolidation tasks.
  • Use Workflow to assemble multiple scripts and execute them as a group.
  • Schedule and monitor Workflows to execute data consolidation 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 consolidation easy.
  • The Data Consolidation 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.


Performance, Simplicity, Flexibility.

-



The Data Consolidation 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 consolidation transformations after data is brought in from different data sources.