FLOWCAL Database Connection

FLOWCAL Database

The FLOWCAL Database connection is used by the asiFlowCalScadaRequest Service which monitors the FLOWCAL database for GC Write Request processing.

Provider

The database provider: Microsoft (MSORADB), Oracle or Custom. Note: The 32-bit version of the Oracle client is required for the 32-bit version of ACM.

Database name

The name of the FLOWCAL database to be used.

Authentication/User name/Password

The authentication information required for secure access to the database.

Custom

If using a Custom provider, enter the custom or provider-specific connection string.

Oracle Connection Example

Sample setup

FCPROD is the name of the listener on the FLOWCAL machine.
VMFLOWCAL2 is the name of the FLOWCAL machine.
FLOWCAL is the name of the FLOWCAL database.

Custom connection string:

Provider=OraOLEDB.Oracle.1;Data Source=FCPROD;User Id=User1;Password=Pwd;UseSessionFormat = TRUE;

tnsnames.ora file:

FCPROD = 
     (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = VMFLOWCAL2)(PORT = 1521))
          (CONNECT_DATA =
                 (SERVER = DEDICATED)
                 (SERVICE_NAME = FLOWCAL)
           )
      )

Test Connection

Use this to confirm that the authentication information is correct. The Windows Authentication option will attempt to connect under the asiFlowCalScadaRequest user account.

Test Connection as User

Use this to test the connection under a different windows user.

Enter the User name (DOMAIN\User) and password for the user in question.