“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.
Matrix Features
Skalable Matrix is an ETL tool with a wide variety of features that help customers to integrate data between applications simply, quickly and accurately.
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 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