Data Cube Overview
With Data Cube, you can collect structured and unstructured information in various types of data repositories across your enterprise. You can then search, edit, combine, share, and visualize your connected sources and transform your data into real business intelligence all from the Data Cube interface in the Web Console.
How Data Cube Works
Data Cube is a tool for connecting your data. Whether your data resides in multiple databases, file systems, spreadsheets, or other unique data structures, the features of Data Cube enable you to gather all of your data into one interface, refine the structure to suit your needs, and then output the data to create custom search interfaces or fulfill other business needs.
The following steps outline the process for using Data Cube:
- Identify the data repositories in your environment:
Data Cube supports many popular data types with native data connectors. You can also connect to a custom data source with the Open Data Connector.
- Connect to your repositories from Data Cube:
Complete a simple form to allow Data Cube to connect to your data repositories. Also, you can specify criteria to filter out the data that you don't need.
- Import data from your sources into Data Cube:
Data Cube uses the Analytics Engine, a lightweight indexing engine included with every MediaAgent, to crawl the data residing in your data repository. Depending on the type of data connector you use, metadata and content information are copied from the data repository and stored in an index on the Analytics Engine. You can also send a POST request to upload data from your data sources directly to the Analytics Engine.
- Search, visualize, share, and use REST APIs to turn your Data Cube sources into business intelligence:
Once your data is indexed in Data Cube, you can access, search, edit, change, and combine data sources to suit a variety of business needs. Using SnapProtect and other leading business intelligence tools, you can visualize your data to discover valuable insights. You can also restructure your data and save different data views, all without ever affecting the original data residing in the data repository.
Key Features of Data Cube
The following features are available with Data Cube:
Collect Data from a Variety of Sources
With Data Cube, you can connect to a variety of structured and unstructured data types. Data Cube provides native support for a variety of data types and third-party services, as well as the ability to define your own data structure and create custom data sources.
Native Data Connectors
Data Cube provides several data connectors to collect information from a wide array of popular data types and third-party software services. After providing some basic source details, you can use the following native data connectors to instantly pull information from your various data sources into Data Cube:
- Oracle, Microsoft SQL, and other types of databases.
- Third-party data services, such as SalesForce and Eloqua.
- Desktop, laptop, and server file systems.
- Microsoft Active Directory and other LDAP directory services.
- Microsoft Excel spreadsheets and CSV files.
- Internal or public websites.
Open Data Source Connector
With Data Cube, you are not limited to native data connectors. The Open Data Source connector enables you to create your own data sources. After defining the data source schema, you can upload the data using the RESTful APIs provided by Data Cube for your custom data source.
View, Edit, Share, and Combine Data Sources
Once you create your data sources in Data Cube, there are a variety of features that enable you to configure your data to suit a particular business need.
After connecting to a data source with Data Cube, you can view your data using a built-in search interface. The Data Cube search interface allows you to search, filter, sort, and refine your data. You can also create multiple different search views for each data source for different needs.
Restructure Data Schemas
Each structured data type has a schema. The schema consists of data field names and other information about the types of data that are stored in a particular data source. Once data has been imported into Data Cube, you can fully customize the schema of structured data sources by adding or removing fields, changing data field types, reformatting data, and redefining which aspects of your data are stored in the Analytics Engine index.
Combine Data Types with Search Federator
You can combine data from different data sources into a single entity with the Data Cube Federated Search connector. The Federated Search connector enables you to combine data sources and handlers into a single data source that works with the complete array of Data Cube features.
Create Request Handlers
Data Cube handlers enable you to create customized requests to retrieve data from your data sources. You can use handlers to create a custom search application using specific slices of data from your data sources.
Transform Data into Business Intelligence with Visualization Tools
With Data Cube, you have multiple options for transforming your data into business intelligence with leading visualization tools and software.
SnapProtect Build Your Own Reports
Data Cube is fully integrated with SnapProtect Build Your Own Reports. With one click, you can import data sources into the Report Builder dashboard and create visualizations of your data. You can also combine different data sources in a single report to create graphs, charts, and other visual aids to help translate your data into insight.
Third-Party Business Intelligence Software Support
Data Cube data sources are fully supported by Tableau and Microsoft Power BI, so you can enhance your existing workflow with all of the Data Cube features.
Integrate Data Cube with External Services
With Data Cube, you can serve the information in your data sources and integrate the data in your enterprise infrastructure into leading corporate platforms, such as SalesForce. This means you can search, view, and download data residing in your CommCell environment directly from your SalesForce dashboard.
Use RESTful APIs to Interface with Data Cube
With Data Cube, you can use RESTful APIs provided with each data source to integrate your data sources with external applications. Data Cube supports both HTTP GET and POST requests, samples of which are provided for each data source. The required API authentication tokens ensure that your data remains secure when developing with Data Cube REST APIs.
Getting Started with Data Cube
Data Cube requires some configurations to be performed from the CommCell Console. To get started, see Getting Started with Data Cube.