Analytics AgileConnector

AgilePoint Analytics API URL

Description:

Specifies the runtime URL for Analytics Center in your environment, followed by /api.

Allowed Values:

Analytics Center URL, followed by /api in this format:

[Your AgilePoint NX Portal URL]/AnalyticsCenter/api

Default Value:

None

Example:

https://myagilepointnxdomain.com/AnalyticsCenter/api

The domain name for the production environment changes based on the configuration of your environment.

Connection String

Description:

Specifies the connection string to connect to the Analytics database.

Note: AgilePoint Analytics supports a logical multi-tenant architecture, and AgilePoint Sever is based on a physical multi-tenant architecture. Because of this, the workflow databases are separate for each tenant, but the Analytics database is shared across all tenants.

Allowed Values:

A connection string for the Analytics database.

The connection string must be in a specific format for this field.

Values identifying the database server:

• application name=AgilePoint Server

  This value is a literal constant. It must not be changed.

• server=[the name of the database server for AgilePoint NX]

  Complete this value with your database server name.

• database=[the name of your Analytics Center database]

  The name of your Analytics Center database. By default, this value is AP_Analytics_DB.

Values identifying the connection credentials:

• Either enter this value for a trusted connection:
  • trusted_connection=yes
• Or enter these values to use specific authentication credentials:
  • User ID=[database user name]
  • Password=[database user password]

This results in 2 possible formats for the Analytics Center connection string entered in this field, which are both different from the connection string value in the Analytics Center configuration file:

• application name=AgilePoint Server; server=[the name of the database server for AgilePoint NX]; database=[the name of your Analytics Center database]; User ID=[database user name]; Password=[database user password];
• application name=AgilePoint Server; server=[the name of the database server for AgilePoint NX]; database=[the name of your Analytics Center database]; trusted_connection=yes;

Default Value:

None

Example:

• application name=AgilePoint Server;server=MyDatabaseServer;database=AP_Analytics_DB;trusted_connection=yes;
• application name=AgilePoint Server;Server=MyDatabaseServer;database= AP_Analytics_DB;User ID=bobsmith;Password=pass1234;

Connect

Function:

Verifies whether the specified connection string is correct.

Reset Analytics Sync Operation On Next AgilePoint Service Start

Description:

Specifies whether the Analytics AgileConnector synchronizes all of the data from the AgilePoint NX databases with Analytics Center after the next time you restart AgilePoint Server.

Allowed Values:

• Deselected - The AgileConnector synchronizes only new or changed data from the AgilePoint NX workflow and Data Entities databases.

  This is the default mode of operation. It is recommended for typical system use.

• Selected - The next time AgilePoint Server restarts, all of the data from AgilePoint NX workflow database and Data Entities database with the Analytics Center database. After synchronization, this field gets deselected by default.

  This operation overwrites all of the data in the Analytics Center database, and replaces it with the data in the AgilePoint NX workflow and Data Entities databases, whether the data is different or not.

  This may be useful if you suspect that the data is not synchronized between AgilePoint NX and Analytics Center, or if there is an unusual circumstance, such as if you perform a manual upgrade on the Analytics Center component. However, this synchronization can take several hours to complete.

Default Value:

Deselected