Create a new connection

  1. Click  Get Data.
  2. In the top right corner, click  New.
  3. Select from the list of available integrations (accounting system).
  4. In the Create new connection dialog box, enter:
  • Server Name: Enter server name or the IP address of your SQL server (name\instance) where your accounting database is stored.
  • Database: Enter the database for the accounting system. (The picture shows and example for Visma Business.)
  • Authentication: Select authentication method, either SQL or Windows.
  • Login: Leave empty if you want to use Windows authentication or enter SQL user for accessing the accounting databases. This requires minimum read access rights to all databases, including the system database. However, if you plan to do budgeting with write-back to the ERP system, you need to have both read and write rights to all accounting databases.*
  • Password: Leave blank if you are using Windows authentication or enter the password for the SQL user.
  • Allow other users to edit this connection: Turn on the switch if you want other users to be able to edit this connection.

5. Click Next.

Now, you get a list of available company databases.

6. Select company or companies from the list.

NOTE: You can use the Search for companies box to search for companies in your database.

7. Click Next.

8. In the Connection name field, enter a name for your connection.

9. Select the voucher provider you use or click None. The picture shows an example where Visma Document Center is used.
NOTE: If you select None, you will not set up the voucher view option and you can go directly to step 9.
NOTE: This step is not visible for all integrations.

10. In the Document center path field, enter the path where the vouchers are stored. It is important that the portal or Voucher Service has access to this folder.

11. When you have added the document center path, click Finish.

 

Edit a connection

  1. Click  Get Data.
  2. Click the connection you want to edit.
  3. In the top right corner, click  Edit.
  4. Click Next to get to the step you want to edit.

 

Delete connection

  1. Click  Get Data.
  2. Click the connection you want to delete.
  3. In the top right corner, click https://help.onestopreporting.com/wp-content/uploads/2017/03/btn_delete.png Delete.
  4. Click Delete to confirm the deletion.

NOTE: When you delete a connection, you also delete the following related data:

  • Data access filters
  • Budget flows
  • Publisher jobs
  • Reports (not report templates)