Access, Transform, Store and Share Data at the Speed of Business.

XDI provides the data integration capabilities to:

  • Eliminate Data Silos
  • Unify Company Data
  • Drive Productivity
  • Centralize Data Storage

The Importance of Data Integration

With digital transformation, data is more central and vital, and its management is becoming increasingly complex. Data is everywhere within the utility and often housed in different spreadsheets, databases and devices. To bring data together for real-time analytics and decision making, utilities need to create a fully integrated and sharable data source.

Data integration eliminates data silos, simplifies the number of connections between data sources, and manages the conversion of data between formats to ensure that the right data is always available as a single source of truth.

Cross Data Integrator
[XDI]
Trusted Data at Your Fingertips
Cross Data Integrator [XDI] frees data from silos and enables companies to access all their data, no matter where it’s located or the format it’s in.

Cross Data Integrator combines the benefits and efficiencies of a data pipeline and manager with the trusted validation of a data warehouse. Using active metadata, semantics and machine learning capabilities, XDI creates a fully integrated and shareable data resource between utility departments and business units to enable faster access and improved decision making.

Data Integration Made Easy

Make Your Data Useable and Trusted, Not Just Stored
Data Manager

Cross Data Integrator’s Data Manager connects and transforms data from databases, data warehouses, spreadsheets, and other data sources into a unified structure for consumption or storage.

Key Data Management features:

  • Quick Configuration – Prebuilt connectors and schemas require little to no configuration for most applications or can be custom-designed using our Integration Designer.
  • Universal Connector Library –Enables immediate connectivity to all data sources (e.g., databases, spreadsheets, and archival data sources) using CSV, Excel, JSON, XML, Text, and other database connections.
  • Schema Management – Quickly identify each data source, and which data tables need to be queried for extracting the necessary data.
  • Data Normalization -Prepares and transforms data into a unified structure using the ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) transformation processes.
  • Standards Based – Uses industry protocols, data formats, and transformation methods to ensure compatibility.
  • Advanced Security – Enterprise-grade security and encryption to ensure data is protected from extraction through the entire transformation process.
  • Graph and Cognitive Analytics – Analyze relationships between entities and unlock deeper value through intelligent technologies.

Cross Data Integrator employs an elastically scalable architecture that can handle large volumes of data, perform complex operations to multiple types of data, and provide detailed business and process insights at near real-time.

Data Warehouse

A centralized data archival and storage solution that eliminates data silos, centralizes the data, and makes it available for use across the organization as THE single trusted location for all information.

Key Data Warehouse features include:

  • Flexible Storage - can be provided as a SQL, No SQL, Time Series, or Graph.
  • Multi-Tiered Architecture -Three options for integrating transformed data to the Data Warehouse 1) directly, 2) through domain-specific Data Marts, or 3) through Data Marts and OLAP Cubes.
  • Data Consolidation & Storage – Consolidate data from Data Lakes, Data Hubs, Data Virtualization, Data Federation, Data Warehouses, and Operational Data Stores.
  • Single Source of Truth –Centralizing data ensures that everyone across the company has access to the same data.
  • Built in Security - Enterprise grade security to protect the data throughout the entire cycle - from the time it’s extracted to the time it’s consumed/archived.
  • Data Modeling – Create scalable data models with rules and structures that meets the business requirements for each project.
  • Fully Managed –Easy-to-use interfaces allow full control of data processes and accessibility.
  • Scalable -Tiered Data Warehouse options that are scalable and grow as business requirement change.

Centralized Data Storage

The Foundation for Business Intelligence and Analytics

One type of data structure doesn’t fit all needs of data Business Intelligence applications, so the XDI Data Warehouse was designed to support multiple structures, including SQL, NoSQL, Time Series, and Graph.

SQL

Structured Query Language is a database format where the data is stored in tables, and relationships exist between the data (i.e., relational database). Data is a predefined schema that is suitable for complex queries.

NoSQL

A distributed database structure where data is stored in documents and doesn’t have relationships between the data. Data schemas are dynamic, enabling support for hierarchical data storage.

Time Series

A time series database (TSDB) is ideal for data that is time-stamped, making it easy to analyze and identify changes over time.

Graph

An asset compliant transactional database where data is stored as a graph. Graph theory is used to store, map, or search relationships and is an ideal structure for businesses with complex relationships or dynamic schema.

Cross Data Integrator

Cross Data Integrator [XDI] is part of the 3Insys Integration Suite and was designed as a modular solution to address the data integration requirements for utilities and Smart Cities. XDI can be used as a standalone product or can integrate seamlessly with both Cross System Integrator [XSI] and Cross Security Manager [XSM] to deliver a complete end-to-end integration solution.

Cross Data Integrator

Eliminate Silos

Extract, combine, and unify data from all sources across the company for consumption or archive

Intelligent Preparation

Transforms and prepares data into a unified view using pre-defined or custom schemas

Intelligent Preparation

Transforms and prepares data into a unified view using pre-defined or custom schemas

One Source

Unified data in a Data Warehouse provides a single source of truth for all current and historical data

One Source

Unified data in a Data Warehouse provides a single source of truth for all current and historical data

Improved Results

Business decisions can be made using a single source of trusted data

Cross System Integrator

Simplify Integration

[XSI]

Cross Security Manager

Unify Security

[XSM]

Cross System Integrator

Simplify Integration

[XSI]

Cross Security Manager

Unify Security

[XSM]