A module that ensures connectivity with your ERP, directly integrated into Companion® Office

A powerful data transformation engine that connects the solutions of the Companion® suite to any integrated management software package (ERP).

A module that allows the exchange of data in real time between your integrated management software package (ERP) and the Companion® suite.

Make sure you exchange all information bidirectionally between the Companion® suite applications and your ERP.

Share the information

Enterprise-wide integration to promote real-time information sharing.

Optimize your departments

Business processes that are integrated and communicated across all departments and business units.

Manage centrally

A common database that allows data to be defined once for the business.

For more information on Companion® Link

Download the technical sheet

How does Companion® Link work?

Companion® Link automates the reconciliation of data between a source and one or more destinations, allowing customization of data extraction and transformation. These exchanges can be as simple as the entire contents of a database table, and as complex as a query with multiple conditions spanning different tables. Script and event functionalities allow you to create any data interfaces that are necessary. The scripting language can be used at any level of the interface definition, and provides access to a variety of verbs. The event cascade can be used to initiate sub-processes and allow a high degree of dependency between data as needed.

Connect

Companion® Link offers connectors for Companion’s internal applications and for many external applications. They perform the extraction of the data that you then want to transmit automatically to satellite systems such as: SAP Business One *, SAP S4 Hana, Oracle, Infor, Microsoft Dynamics, NAV, Sage 300, SQL Server, text files, Power BI, etc.


Transform

Companion® Link allows any type of transformation to be applied to the master data in order to adapt the content to the needs of the recipient systems, whose particularities are numerous and constantly evolving.


Validate

Companion® Link provides the automatic validations necessary to ensure that the exported data has the desired level of precision. The system event monitor allows the authorized user to consult information and statistics related to these events: number of lines to be processed and of lines processed; to insert and inserted; to be updated and updated, etc.

Our solutions represent an extremely beneficial investment for your business’ growth.

Still need convincing?

Discover the anticipated ROI with our solutions!

Companion® Link is the key module integrated into the Companion® suite

blank

blank blank

SFA-CRM

CIS-Companion® Rep

A modern application to help manage the activities of representatives or merchandisers.


Learn more
blank

blank blank blank blank

DSD

CIS-Companion® Route

An efficient software package to promote the management of your route accounts.


Learn more
blank

blank blank blank  blank

Companion® Office

Powerful middleware to control your application settings and analyze data.


Learn more

Companion® allows you to connect with all the integrated management software packages (ERP) on the market, but also with your in-house accounting software.

blank

Opt for the connectivity solution that can be interfaced with all types of accounting or ERP software.

Our solutions offer much more than traditional ERP data. You can complete the information gathered with our extremely comprehensive and powerful tools and benefit from a much richer information collection.

Quickbooks online | Quickbooks | Sage 300 | Sage 50 | Sage X3 | Acc Pac | SAP B1 | SAP ECC ORACLE | Microsoft Dynamics NAV | Infor | Acomba

Learn more

Find out how our Companion® Link module ensures the link between your ERP and the various software of the Companion® suite to maximize your performance.

A data transformation interface (ETL)

ETL is a type of data integration that refers to the following three stages: extract, transform, and load, which are used to aggregate data from multiple sources.

The data interface is often used to create a data warehouse. In this process, data is extracted (extracted) from a source system and then converted (transformed) into a format that can ultimately be analyzed and stored (loaded) in a data warehouse or other complementary system. Extract, Load, Transform (ELT) is an alternative, but related approach designed to push information from different sources into a common database.

In companies, many complex and sometimes complementary systems lead to a flow of data and information, sometimes containing redundant and inconsistent data between them. In order to improve different business processes, it is essential for companies to collect as much information as possible to promote effective analysis and decision-making.

It is essential to take advantage of existing IT resources to create data processing and transformation systems that are more flexible and agile, which will promote the sharing of data between the different systems and thus avoid the duplication of information.

The transformation of the data corresponds to the T in ETL. Data transformation means that data entered in a format is processed, inside or outside the database, and then converted and kept in the required new format. This transformation can be done in a variety of ways, ranging from column storage types, to file types, or even encoding types. There is no one “database” solution for businesses. All data can therefore end up in completely different locations and formats, making data transformation necessary to ensure that data from an application or database can be shared with other applications. and databases.

Concretely, the transformation, in the ETL process, will make it possible to extract data from its current form and convert it into the right format so that it can then be placed in another database. The transformation occurs using rules or lookup tables, combining the data with other data that was not necessarily compatible. Thanks to this transformation, the various databases of a company will be able to better share the information stored there. This will make it easier for managers to consult all of their company’s data, which will allow them to better analyze the information coming from the various databases.

Companies have relied on the ETL process for many years to gain a more complete view of all the data available to make more informed business decisions. Today, this method of integrating data from multiple systems and sources is still a considerable advantage of an organization to allow the grouping of all data and ensure a uniform reading of the available information.

When used with an enterprise data warehouse (data at rest), ETL has the ability to provide deep historical context to the enterprise.

By providing the big picture, ETL enables skilled users to easily analyze and interpret the data made available to help managers make decisions that are informed by real, relevant data.

ETL can also dramatically improve the productivity of data professionals as it has the ability to codify and reuse the processes that are used to move data without resorting to technical skills to write code or scripts.

In addition, ETL has evolved over the past few years and can now support the emerging integration requirements of things like streaming data.

Organizations need both ETL and ELT in order to bring data together, to maintain accuracy, but also to provide the auditing that is typically required during data warehousing, reporting and management. analysis of the latter.

blank

ISO 27001 Certification

CIS Group is an ISO/IEC 27001 certified enterprise. This is a world standard (and includes the ISO/IEC 27002 good practice guidelines) for informational assets security management. It specifies the requirements of an Information Security Management System (ISMS). The ISMS is a systematic approach of the management and security of sensitive data, involving personnel and applying risk management processes to information systems.

View Certificate

Power BI Business Intelligence

Leverage enlightened decision-making by relying on the analysis of your data using powerful Dynamic Dashboards.

24-7 Bilingual Support Available

Be assured of obtaining the service you need when your teams most need it!

Rugged Mobile Equipment

Opt for powerful and durable hand-held computers, scanners, or mobile printers to optimize your efficiency.