Configure AFAS Online Log On with Invantive SQL

AFAS Online provides medium-sized companies with excellent accounting, payrolling and taxes solutions from a hosted environment. In addition to the interactive use, it also provides flexible options for integration through a large number of APIs. Invantive SQL supports all available APIs (so-called “GetConnectors”) to exchange data with AFAS and creates reports. This article explains how to configure the connection to AFAS Online.

AFAS Online and APIs

All Invantive SQL-based products assume that you are familiar with setting up the platforms to associate with. However, as an extra courtesy we provide this sample on how to configure the AFAS Online platform for connections originating from Invantive SQL.

The first step is to start AFAS Online:

  • When signaled, approve log in using the AFAS two-step verification app on your phone.
  • Start the AFAS session by clicking on Profit 10:

  • Note that number ‘87205’ in the heading. This is your environment number. It is needed to select the right environment on log on from Invantive SQL-based products.

App Connector

  • Start the screen to define App connectors:

Start App connector form.

  • Define a custom app connector such as ‘Invantive app’ and remember to apply security validations according to your company needs:

afas-invantive-app-connector

General properties.

  • Check that the connector is not blocked (field “Geblokkeerd” in image above).
  • Define and/or add get connectors to retrieve data to match your needs:

  • Always add the AppConnectorVersion connector as shown below:

  • When you can’t find some Get connector you need, please check that it has not been blocked.
  • Open the window ‘GetConnector’ as displayed:

  • Make sure that the lock is yellow and not red. When it is red: click on it. This ensures that also blocked connectors are included in the list:

  • Find the missing GetConnector and unblock it, like shown:

  • Then create tokens for the individual actual or service users:

  • Select a user and provide some description:

  • Generate and save the generated token for the user:

Save generated app connector token for user.

  • Repeat these step for generating tokens for every user.

The token (including XML-tags such as ‘’) together with the number of the environment is all your need to access the AFAS Online environment.

Additional GetConnectors

All GetConnectors can be used, including those create by the user community as instructed on the AFAS website for custom GetConnectors.

Invantive Log on to AFAS Online

With the environment number and the credentials in the form of a token you can log on.

Interactive Products

The log in from Excel, Word, Outlook, Query Tool, Data Loader or other interactive products is done as follows:

  • Start the application (for instance the free Query Tool).
  • Choose from the Various group the database ‘AFAS Online’ (red 1):

AFAS Online log in from Invantive Query Tool.

  • At the red 2 enter the token generated for the user you wish to log on as.
  • Enter the environment number at the red 3.
  • Press the log in button at the red 4.

The list of available objects will depend on the get and update connectors defined:

AFAS Online available objects.

Using Invantive SQL you can now enter your queries or data replication statements.

Web Products

The log in from web products is done by entering the token and environment:

The available objects here also depend on the connector identical to all other log in variants:

Online SQL editor for AFAS Online.

Server Products

Server products such as Data Hub or the FTP Business Server, allow interactive specification of token and environment, as shown below:

Interactive log on to AFAS Online for server products.

However, the settings*.xml file can also specify default values for password and environment number:

afas-online-with-pre-filled-password-and-environment-number

Pre-defined AFAS Online connection for headless server use.

Note that the XML-tags in the token need to be escaped properly by replacing ‘<’ by ‘<’ and ‘>’ by ‘>’.

Resulting in the following log on process for server products (but also for interactive products):

invantive-headless-log-on-afas-online