Configure Data Service

Before starting the Data Services Windows service, do the following to configure the Data Service:

1. In the installation directory for AgilePoint Data Services (by default, C:\Program Files\AgilePoint\AgilePoint Data Services), run the script DataServiceConfiguration.exe.
2. On the AgilePoint Data Services Configuration window, complete the following fields:
   • Database Type – The type of database you want to use for AgilePoint Data Services. Microsoft SQL Server or Oracle Database.
   • Database Authentication – Indicates the database User name, Password, and whether Integrated Security is used.
   • Database Location - The database to which the data will populate. This can be an existing database, the AgilePoint database, or a new database.
   • Enable Data Population – If selected, allows application data to be written to the database.
   • Enable Data Tracking – If selected, allows changes to application data to be tracked.
   • Time Interval - The timer interval used by the Windows Service to check for any new entries in the database. On a production system, this can be set to a high interval like 3600 (i.e. one hour).
   • Server URL - The AgilePoint Server URL.
     • Windows Service – Open the file Ascentn.AgilePoint.WCFService.exe.config in [Windows Service installation location]\bin. You can find the Windows Service installation location in the Server Manager window in the Location field for the service instance.
     • IIS – In the IIS Manager, Browse AgilePoint Server > workflow.asmx. The URL appears in the Location field in your web browser.
   • Hosting Mechanism – IIS or Windows Service, depending on your AgilePoint Server installation type.

     If you are running AgilePoint Server as a Windows Service, indicating Windows Service creates the binding between the Data Services component and the AgilePoint Server. This setting is required.

3. To create database tables and save the Data Services configuration, click OK.

   This creates tables named WF_DATA_SERVICE_TEMPDB, WF_DATA_SERVICE_ERRORDB, and WF_DATA_TRACKING in the specified database.