Skip to main content

ChapterSage Connection

Chapter 4 — Assigning each database to a client

On the server, each Sage company has its own database. You tell IntegraSys which database belongs to which client, and which software it was kept in: that is what lets you run an extraction.

In this chapter

  • List a server's databases
  • Choose the source software
  • Assign a database to a client
  • Read a database's status
  1. Server
  2. Source software
  3. Refresh
  4. Client
  5. Assign
  6. Extract
Book contents

Before you start

  • The server is declared and answers (chapter 3).
  • The client exists in IntegraSys. An inactive client is not offered.

List the server's databases

The Client databases page before the first list (French screen)
  1. 1. Server and Source software: the server to read, and the software its databases were kept in.
  2. 2. Refresh databases asks the server for its list of databases.
  3. 3. The search filters the databases by their name or by the client already chosen.
  4. 4. Before the first list, the page says what to do.
  1. Choose the Server.
  2. Choose the Source software: Sage 100 (SQL Server) for accounts, Sage Paie (SQL Server) for payroll, SQL générique (mappings) for another software.
  3. Click Refresh databases. For a server linked to an agent, the list goes through it: up to a minute, which the screen recalls while you wait.

One row appears per database. Databases already assigned show up by themselves, even before Refresh databases.

The Client databases page with three databases listed: one assigned (client chosen, status Connected, Extract active), one Unassigned, and an empty search.

Assign a database to a client

Each row has five columns: Database, Client, Fiscal year, Status and Actions.

  1. Under Client, type a few letters and pick the client: the list gives its number and name.
  2. Leave Fiscal year on All fiscal years. The years are chosen at each extraction.
  3. Click Assign. « Assignment saved » appears, the Status replaces « Unassigned » and Extract becomes active.
  4. Extract opens the Extraction screen, with this database already chosen (chapter 6).

As long as no client is chosen, Assign stays greyed out.

A database's status

StatusWhat it means
UnassignedThe database is not linked to any client yet
UntestedAssigned, but no test, list of its years or reading of its columns has opened it yet
ConnectedThe last opening worked, for example to list its years
FailedThe database refused the last opening

The status tells what the database's last opening found. An extraction does not change it: a database already extracted can still read « Untested ». The refresh icon of the Fiscal year column reads the database's years: it is also a good test of one particular database.

Find a database

A large server hosts dozens of databases. Type part of the database's name, or of the client already chosen for it, in the search: the page only shows the matching rows, and their count on the right, « … / … databases ». The cross clears the search.