Auto Connection System

Home > Connector > Data Connections > Auto Connection System

Using the Auto Connection System

In order for Sage Accpac Intelligence to communicate via ODBC to any database, these values need to be resolved:

• Server Name
• Database Name
• User ID
• Password

The Auto Connection System in Sage Accpac Intelligence  is used to automate a Connection between a data server and data source at report execution time.

The Auto Connection System takes care of the above values by passing all these critical values during the company log on process to Sage Accpac Intelligence. Especially if more than one server (Database Host) and database exists on the network, this feature proves very helpful to automate seamless integration to automatically use the relevant logged in server and company.

Notice the following four field variables values of the Connection Properties:

• Server: @AUTO_CONN_SERVER@

  The @ signs indicates that upon report runtime some variable value is expected to be supplied. In the case of the above string it’s the appropriate MySQL Server name to access the data.

  Therefore the relevant MySQL server PC’s name will be automatically supplied by the Auto Connection System.

• Database Name: @AUTO_CONN_CATALOG@

  The above string indicates the expected value to be supplied by the Auto Connection System upon report runtime of any report is the relevant Database Folder.

  Therefore the specific currently opened company’s equivalent Database Folder will be supplied by the Auto Connection System.

• User ID: @AUTO_CONN_USER@

  This string indicates that the MySQL server’s User ID field that is logged into Sage Accpac Intelligence would be automatically supplied by the Auto Connection System.

• Password: @AUTO_CONN_PASSWORD@

  This string indicates the MySQL’s password that Sage Accpac Intelligence is using that would be automatically supplied by the Auto Connection System upon report runtime.

Automatic Query and Response Dynamics

All Sage Accpac Intelligence reports that are run, are passed the Auto Connection Properties (automatic query prompt running in the back ground) for the 4 mentioned variables to be specified first before data can be extracted from the database.

In response the relevant 4 variables values are supplied in accordance with the specific company opened and the relevant MySQL Server PC name.