/ Help centre
A LITTLE GUIDANCE GOES A LONG WAY

How can we help?

Find a clear answer, or a friendly human.

Explore the knowledge base

74 articles
▧Administration › Server Administration

After Upgrade to Version 5 all scheduled Tasks became Unsheduled. Attempts to set a time doesn't schedule them.

Applicable Versions: Version 5 to 5.50 In some instance on Windows 8 and Windows Server 2012 the upgrade to Version 5 does not install a registry entry. To resolve a Registry Entry Key must be added. Import from File Save the following three lines to a file with an extension of ".reg" then…

Read article →
▧Administration › Server Administration

Can DataPA connect to a 64bit server running Progress OpenEdge 64bit?

Applicable Versions: All DataPA support server-side connections to all Progress OpenEdge 10 64bit AppServer configurations. You will however need a procedure library compiled using a 64 bit version of Progress. For the latest release of DataPA, you can download the procedure library here. For…

Read article →
▧Administration › Server Administration

Can DataPA Enterprise be configured to use Microsoft Active Directory for user authentication?

Applicable Versions: 4.5 to 5.5. Please see the article for v6.0 This article describes how DataPA Enterprise can be configured to use MS Active Directory (“AD”) for user authentication, and assigning users to groups. 1. Set-up Authentication AppServer The authentication will be performed by a…

Read article →
▧Administration › Server Administration

Can I connect and retrieve data from an SQL data source?

Applicable Versions: 2.01.0152 Onwards If you require frequent access to an SQL data source, you can use the Progress DataServers to connect the SQL data source to the Progress AppServer (the data servers are licensed with DataPA business licenses. Please speak to your sales representative for…

Read article →
▧Administration › Server Administration

Can I create a query that runs a Progress function on the server to retrieve data?

Applicable Versions: 2.01.0152 Onwards DataPA Supports Business Logic subjects that allow reports and queries to be built using any Progress 4GL code that returns a temp-table. The video below shows an example of how to create a business logic subject, and a report based upon it. The code…

Read article →
▧Administration › Server Administration

Can I store my setup data in a standard XML format rather than DataPA's proprietry dat format?

Applicable Versions: 3.00.0078 to 3.05.0075 NB: This functionality was retired with version 4.00. To allow you to manipulate the setup data, for instance filtering subjects and fields on a per user basis, it is possible to configure DataPA so the setup data is stored in readable XML files rather…

Read article →
▧Administration › Server Administration

Cannot pass the login screen on Chrome when using DataPA embedded.

Applicable Versions: 5.50 Onwards This issue is that when using the chrome browser the dashboard is not accessible in an iframe (logging into the dashboard redirects to the dashboard login page), the same action work in Internet Explorer. The likely cause is a Cross-Origin error. Chrome…

Read article →
▧Administration › Server Administration

Cannot Schedule Any Tasks. Run-time Error '-2146232576 (80131700)'

Applicable Version: Version 5.5.0212 onwards When selecting Ok on the Schedule Task screen of Scheduler Maintenance a Run-time Error '-2146232576 (80131700)' is displayed and the Scheduler Maintenance program Closes The .NET Framework 3.5 ( includes .NET 2.0 and 3.0) Feature needs to be installed.

Read article →
▧Administration › Server Administration

Can reports on DataPA Enterprise be rendered out of process?

By default DataPA Enterprise will render report using the DataPA Enterprise Report Service. This is a 32-bit Windows service. This creates COM objects for the purpose of rendering the reports and under heavy use this can sometimes cause issues with the DataPA Enterprise Report Service itself.…

Read article →
▧Administration › Server Administration

Can the look and feel of DataPA Enterprise by customised ?

Applicable Versions: 3.00.0073 Onwards DataPA provides two Cascading Style Sheets (.css) that allows the modification of the look and feel of DataPA Enterprise to suit individual requirements. These files are located withing the Stylesheet folder of the DataPA Enterprise Installation.…

Read article →
▧Administration › Server Administration

Enable SSL/HTTPS for DataPA Enterprise

To enable SSL on a website in IIS, first select the site under which DataPA is installed (usually Default Web Site), then select Bindings. In that binding, select HTTPS as the Type. You will need to provide an SSL certificate. If you do not have one yet, you can create a temporary self-signed…

Read article →
▧Administration › Server Administration

How can I avoid having to reboot my computer after applying an update to DataPA?

Applicable Versions: All DataPA will prompt you to reboot your PC after applying an upgrade to DataPA if any of the files that need to be overwritten are in use. To make sure you will not have to reboot after applying an update to DataPA, check the following: Make sure there are no copies of…

Read article →
▧Administration › Server Administration

How can I call my existing business logic, in a procedure, from DataPA?

Applicable Versions: 2.01.0152 Onwards DataPA allows you to call Progress ABL functions that generate a temp table to provide data for your reports, queries and dashboard, see Can I create a query that runs a Progress function on the server to retrieve data? for details. Your business logic…

Read article →
▧Administration › Server Administration

How can I configure my AppServer so I do not have to restart all of the agents each time I add or change a business logic routine?

Applicable Versions: 2.01.0152 Onwards If you use Progress ABL business logic functions for calculated fields in a freeform subject (see "Can I create a calculated field based on some Progress ABL Business logic?"), or to create business logic subjects (see "Can I create a query that runs a…

Read article →
▧Administration › Server Administration

How can I log, modify or override the query statement used in all freeform queries?

Applicable Versions: 3.02.0156 and above DataPA OpenAnalytics provides a hook on the server that allows you to intercept and modify the query statement before any freeform query is executed by the AppServer. This allows the administrator to add code to the server to log, modify or override any…

Read article →
▧Administration › Server Administration

How can I manage the automatic update functionality internally, so we control updates to our users rather than it coming from the DataPA website?

Applicable Versions: 3.00.0001 Onwards DataPA's automatic update information can be configured to load updates from your own servers rather than DataPA's. Follow the steps below to configure the update. Create your own update.xml file. You can download the latest update.xml from…

Read article →
▧Administration › Server Administration

How can I monitor agent usage for DataPA Enterprise

Applicable Versions: 6.00.0095 and above An assembly has been created and added to the installation that allows the simple creation of an Open API query to analyse the agent log file. Before you can analyse the log file, you must ensure agent usage logging is enabled on your server. Follow the…

Read article →
▧Administration › Server Administration

How do I change the port on which the DataPA web portal runs?

Applicable versions: 6.0 and onwards Please also see this article on how to change the port on which the DataPA Enterprise Service runs To run the DataPA Enterprise web portal on a different port to that of the default port 80, use the IIS Manager to change the port mapping for the web site…

Read article →
▧Administration › Server Administration

How do I configure DataPA so users can only access certain systems and connections based on their username?

Applicable Versions: 2.01.0152 and above Often you may wish to control which systems and/or connections a user has access to based on their username. The DataLocation determines the location from which the setup files that define systems and connections should be loaded. If the DataLocation is…

Read article →
▧Administration › Server Administration

How do I configure DataPA to connect to MS SQL using an ODBC connection.

Applicable Versions: All If the connection to the SQL database is being made from the DataPA Enterprise Service then a 64bit ODBC connection can be made. If the ODBC connection will be made from the local DataPA Client then a 32bit ODBC must be configured. The following screenshots show an ODBC…

Read article →
▧Administration › Server Administration

How do i configure DataPA to use Microsoft Active Directory for user authentication?

Applicable Versions: 6.0 and upwards. DataPA user authentication can now be configured to directly retrieve users from, and authenticate against, your Active Directory. In Server Settings, under Access Security, you can select Active Directory as one of the options for "Validate users from". The…

Read article →
▧Administration › Server Administration

How do I configure DataPA to use my business application's own username and password for access security?

Applicable Versions: All DataPA can be configured to allow or deny connections to the AppServer based on an existing business applications security, removing the need to maintain user lists in two places. When using connection security, the following occurs when DataPA attempts to connect to an…

Read article →
▧Administration › Server Administration

How do I configure the Enterprise Service to use HTTPS/ SSL?

see The Enterprise web portal does not receive live updates such as published dashboards and alerts.

Read article →
▧Administration › Server Administration

How do I configure the security settings of a DataPA client from the server, based on the user's username?

Applicable Versions: 2.01.0152 and above Security settings that determine whether or not users can change systems, links and subjects are critical if the security of the business application is to be maintained. To ensure these settings are maintained as designed, regardless of the client…

Read article →
LET’S WORK IT OUT

Still looking for an answer?

Ask our help assistant, or get in touch with the team.

Email support@support.helpdesk.inmydata.ai ↗

AI can make mistakes. Contact our team if you’re unsure.