SKALABLE MATRIX
FEATURES & INTEGRATIONS

“Are you struggling to integrate data between applications?“

SKALABLE MATRIX IS AN ETL APPLICATION THAT MAKES DATA EXTRACTION, TRANSFORMATION AND LOADING A SIMPLE AND EFFICIENT ACROSS BUSINESS APPLICATIONS.

MULTI-TENANTS CONCEPT

Matrix has ability to support Multi-Tenant concept where a single instance of software runs on a server and serves multiple customers.

ROLE BASED SECURITY

We can restrict System access through Role base security in Matrix.

CONNECTIONS

Matrix can maintain parameters to connect with 3rd party applications such as Oracle NetSuite, Salesforce, D365, etc.

DASHBOARD

Interactive dashboard which shows the status of all integrations. The Dashboard will show the details:

  • Process are in Queue
  • Integration in-progress
  • Successful integrations Vs Errors

CLOUD STORAGE

All the integration, process and log files are stored in the cloud for easy reference. This eliminates the need for local server maintenance costs.

MANUAL UPLOAD

Matrix can also do manual integration with flat files.

DATA SYNCHRONIZATION

Matrix has the ability to design the integration task with mappings between different applications tables or entities.

LOOKUP TABLE

Matrix has the ability to design the integration task with mappings between different applications tables or entities.

ACTIVITY LOG

Matrix will show the logs for all inbound integrations.

OUTBOUND INTEGRATION

Matrix supports outbound integration. For example, it can pull the data from the source applications, process a report and integrate the relevant data into other applications.

EXPORT LOG

Matrix will show the logs for all outbound integrations along with the integration status.

TIME SERIES INTEGRATION

Matrix will capture the IoT records and integrate into Azure insight

SQL INTEGRATION

Matrix have ability to store the flat files as tables in SQL

TASK BACKUP

We can take the configured task backup for restoring in other instances

SCHEDULING

Matrix can schedule the integration tasks based on time zones.

We can schedule the recurrence integration tasks as well.

INTEGRATION ALERTS

Success and error alerts for all integration tasks are configurable in Matrix

FLAT FILE TO  D365 F&O

Flat files from Concur, Velocity, Real Page, Opstech, and other 3rd party application file with formats like .txt, .csv, and .XML can be integrated into D365 Finance and Operations

CONCUR FLAT FILE TO  D365 F&O INTEGRATION

Here the use case demonstrated to integrate the Concur application file into Microsoft Dynamics 365 for Finance and Operations.

Sample Concur file

This file contains the pipe delimiter and in .csv format

This file contains the pipe delimiter and in .csv format

VELOCITY FLAT FILE TO  D365 F&O INTEGRATION

Here the use case demonstrated to integrate the Velocity application file into Microsoft Dynamics 365 for Finance and Operations.

Sample Velocity File

This file is in .XML format

Velocity File integrated into D365 F & O as Invoice Journal

OPSTECH FLAT FILE TO  D365 F&O INTEGRATION

Here the use case demonstrated to integrate the Opstech application file into Microsoft Dynamics 365 for Finance and Operations.

Sample Opstech File

This file is in .TXT format with Tab delimiter

Opstech File integrated into D365 F & O as Invoice Journal

REALPAGE FLAT FILE TO  D365 F&O INTEGRATION

Here the use case demonstrated to integrate the Realpage application file into Microsoft Dynamics 365 for Finance and Operations.

Sample Realpage File

This file is in .csv format with comma delimiter

Realpage File integrated into D365 F & O as General Journal

FLAT FILE TO  NETSUITE

Flat files from 3rd party application file with formats like .txt, .csv, .XML can be integrated into NetSuite

ROLE BASED SECURITY

We can restrict System access through Role base security in Matrix.


FLAT FILE TO  GREAT PLAINS ( GP )

Flat files from 3rd party application file with formats like .txt, .csv, .XML can be integrated into GP

SALESFORCE TO  NETSUITE

Sales Order, Sales Quotes, Customers & contacts etc., can be integrated from SFDC to NetSuite

SALESFORCE TO  GP

Sales Order, Sales Quotes, Customers & contacts etc., can be integrated from SFDC to GP

D365 F&O TO  FLAT FILES

ERP data’s can be exported as a report

Trial Balance Report Extraction

This use case explains the data extraction from D365 F & O by Matrix, the output file in the excel format.

Matrix will export the Data from D365, process it and design the TB report and drop it into the SFTP folder.

SQL  INTEGRATION

Matrix have ability to store the flat files as tables in SQL Database

4300 Stevens Creek BLVD,

STE 140, San Jose, CA 95129

+1 408 890 5066


©Copyright 2020. All Rights Reserved.