Already have your data in your ERP? No reason to do double entry or worry if LaborChart has the latest data. Let our integrations take care of things!
For the QuickConnect SQL query integration, we offer the following integration points:
To properly add your integrated data to the right Groups in the LaborChart app, we need to establish a mapping between values in your system to our Groups. These mappings can be 1 to 1, or 1 to many and can be exact matches, partial matches, ranges or other types of conditional logic.
First Character = "5"
To access your ERP's database for the integration, we will need to be provided with the following:
Amongst many other security measures, our integration will only connect to your system via a pre-specified, outbound IP address and port. Allowing you to create a firewall rule to only allow an outside connection from that exact location. This ensures no one else can try to connect to your database using our credentials. To learn more about the steps we've taken to keep your connections safe, schedule a call with your LaborChart technical specialist.
For each entity type you wish to integrate, we need the criteria you would like to use to consider that entity "valid" for integration into LaborChart. This criteria can be as simple as evaluating a single boolean property or more complex if you need it to be. This can be useful to prevent pulling years of inactive data in your LaborChart account if it's stored in your ERP.
To make sure you get all the data in LaborChart that you are looking for, we allow you to specify the exact fields you would like pulled in from your ERP. We can start your off with our recommendations per your specific platform and then let you make any alterations past that point.
You will be provided with a CSV file via your account executive to use to establish these mappings. Filling it out will look something like below:
Ex. (For People)
Note: Although properties from different DB tables can be used to populate the LaborChart fields for a single entity, the tables must be merge-able via SQL so all relevant data for an entity can be retrieved in a single query.
Some clients prefer to ignore certain fields on updates. What this allows is for LaborChart Users to manually override data that was added via the integration without having the next run of the integrations clear out their changes. This is by no means required for every companies' implementation but can be a useful tool if you need it.
The LaborChart QuickConnect integration runs on a scheduled basis. All you have to do is let us know what times you want yours to process. A recommended approach is to do an early morning sync before everyone gets into the office and another update during lunch to make sure the platform is updated for the remainder of the day.