3 - Setting up automated data import into Sage 100

3 - Setting up automated data import into Sage 100

This guide walks you through installing the BrynQ Agent on your local server and configuring it to automatically import payroll data into Sage 100. Once complete, imports will run automatically — no manual file handling required.

Alert
Before you begin — have these three things ready
  1. The BrynQ Agent installer — Log into https://app.brynq.com, go to Organization → Agent, and download the latest version. It will land in your Downloads folder.
  2. An API token (ngrok key) — Request this from support@brynq.com. Store it in a text file; you'll paste it during installation.
  3. An import data file for each company — BrynQ supplies these. Each file contains the employee data for one Sage company (matricule, name, date, etc.). If you manage multiple companies in Sage, you need one file per company.

Installation steps

1. Launch the installer and accept the license agreement
Open the installer from your Downloads folder. The first screen presents the license agreement. Accept it to proceed.

2. Enter your ngrok API key and customer subdomain
The installer asks for two identifiers:
ngrok API key — Open the token file you requested from support, copy the key, and paste it into the field.
Customer subdomain — This is the subdomain shown in your BrynQ URL. For example, if you log in at https://demo.app.brynq.com

3. Configure the agent port
The Agent runs locally on your network. The default port is fine for most installations — leave it as-is and click Next.
Info
Note for IT: If another application is already using this port, you can select another port. Remember it for the final step of this installation manual

4. Select the three required services
Check all three of the following services — each one is needed for the full automation to work:
  1. File endpoint — Enables sending the Excel import file automatically to your server.
  2. SQL endpoint — Allows reading data back from the Sage database (Sage stores its data in SQL).
  3. Sage 100 France — The core Sage 100 integration component.
Click Next.

5. Connect to your SQL server
This step links the Agent to the database where Sage stores its data. Uncheck the "use existing SQL settings" option to configure fresh settings, then fill in the following:
  1. ODBC driver — Select "ODBC Driver for SQL Server" with the highest version number available on your server (e.g. 18, 17, 16). Always pick the highest.
  2. Server name — Open SQL Server Management Studio (click Start → search for it). When it opens, the server name is pre-filled in the connection dialog. Copy it with Ctrl+C and paste it into the installer field.
  3. Authentication — Choose Windows Authentication . This works in nine out of ten installations. Only use SQL Server Authentication if your specific setup requires it.
Click Next. The installer will automatically test the connection. If the test fails, an error message appears — double-check the server name and try again.
Info
Test tip: Entering a wrong server name on purpose is a good way to verify the validation is working. You'll see an error, which you can dismiss, correct the name, and continue.

6. Select the databases
The installer shows all databases it can reach on your SQL server. Sage typically creates one database per company. Select the database(s) the Agent should have access to, then click Next.

7. Select the Sage PRH file(s)
The PRH file is the company file that Sage uses when you open a company. You need to point the installer to this file. If you manage multiple companies, add one PRH file per company. Click Next when done.

8. Configure the payslip export folder
If you want to export payslips from Sage to upload into Factorial, enable this option on the next screen. The installer will create a dedicated folder structure for you.
Click Browse and select a location — for example, a folder called: Sage on your C drive. The installer creates a main payslip export folder there, with a separate subfolder for each company automatically.

Notes
Important: Payslips must be exported from Sage manually each month and placed in the correct company subfolder. The Agent handles uploading them from there — but the export from Sage itself is a manual step.
Click Next.

9. Link the import data file to each company
The installer shows a dropdown of all the companies it found. For each company, select the corresponding import file supplied by BrynQ and link them together.
If you see a warning that a file already exists, that is expected on re-installations. Click Yes to overwrite. On a first-time install, you will not see this warning.
Click Next.

10. Create a dedicated service user in Sage
The automated import will run under a dedicated Sage user account. You need to create this account now. Place the Sage and installer windows side by side on your screen for this step:
  1. In Sage, navigate to user management and create a new user.
  2. Give it a recognizable name (e.g. "BrynQ service user")
  3. make sure the token is set to Active
  4. Click Generate token
  5. in Sage, select and copy the generated token.
  6. Paste the token into the corresponding field in the installer.
  7. Enter the same username in the installer
  8. click OK in Sage to save the user.
  9. Once the new user is saved, close Sage completely (both the company and the application itself — this is required for the next step).
  10. Click Next in the installer.
11. Locate the ConnectImport.exe file
The installer needs to know where Sage's ConnectImport.exe is located. This executable is what creates the automated import definition inside Sage.
In most installations, the file is already at the default path shown. If it isn't found there, click Browse and navigate to your Sage installation folder to find it manually. Once selected, click Next.

12. Configure the import definition in ConnectImport
This is the final configuration step. The installer provides numbered on-screen instructions — follow them in order:
  1. Click Open ConnectImport Now (the button in the installer).
  2. Log in with your regular Sage credentials (your standard demo or admin user — not the service user created in the previous step).
  3. In ConnectImport, set the Répertoire Importé (import directory) to the path shown in step 4 of the on-screen instructions. You can copy-paste the path directly.
  4. Scroll down and check the two top checkboxes in the import settings.
  5. Save this configuration by giving it a name — for example: Factorial import
  6. Copy the configuration code shown and paste it back into the installer field.
  7. Close ConnectImport. Click Next in the installer.

13. Complete the installation
Skip the desktop shortcut prompt if you don't need it, then click Next and Install. The installer will set up all selected services. This may take a few minutes.

Verifying the installation

Open a browser on the server and navigate to localhost:7071. You should see the Agent dashboard with all your configured settings listed:

  1. SQL connection settings (you can adjust these here if needed later).
  2. Sage 100 France settings — verify these look correct.
  3. LDAP, REST, and SOAP sections — these are not relevant for this setup; you can ignore them.

    • Related Articles

    • 2. Run an Employee Data Import in Sage 100 France

      This article explains how to import employee data into Sage 100 France. Import the Data File into Sage Overview After the import format is ready, you can import the real data file (for example, data exported from Factorial). This part of the article ...

    • 1. Setup the import for Sage 100 France Data

      This article explains how to create an import format in Sage in order to import employee data. Create the Import Format in Sage Overview Before you can import data into Sage, you must create an import format. This format contains all the fields ...

    • Determine Interface Scope

      This guide explains how to create and manage interfaces between two systems (source and target systems) within our platform. It includes creating a new interface, defining scenarios, detailing fields per scenario, and submitting your setup for ...

    • Introduction

      Many organizations use the information architecture principle that one data source is leading. In order to realize this principle, an interface has been developed that exchanges data between various applications. For the exchange of data, the ...

    • Connect with DATEV

      Connecting DATEV with BrynQ With BrynQ you can connect your DATEV environment so that employee and payroll data can flow automatically. This guide explains what you (or your DATEV administrator) need to prepare and how to connect inside BrynQ. What ...