How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
256 articlesHow can I modify the AppServer connection details for a given connection using ABL code?
Applicable Versions: 5.00.0050 and above It is possible to access all the various properties of the DataPA System elements (Systems and their Connections) using an API class added in DataPA OpenAnalytics 5.00.0050. This is called the QueryEngine and it is documented here. You can retrieve a…
Read article →Administration › Server AdministrationHow 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 →Developers › DevelopmentHow can I pass a parameter to a dashboard using the URL or Form Parameters?
Applicable Versions: 4.05.0075 and above This knowledge base describes the two methods to implement dashboards that display information based on a parameter passed from a browser based application. If the dashboard is set to refresh queries when it is opened, you can pass required parameters to…
Read article →Developers › DevelopmentHow can I programatically set defaults for the DataPA Exports in my application.
Applicable Versions: 3.05.0035 and above It is possible to set the default values programatically using several sets of properties. A generic property DefaultExportPath can be used to set the Default Path to be used by the exports, additionally there are several export Objects available to set…
Read article →Developers › DevelopmentHow can I programmatically apply a license to my client?
Applicable Versions: 5.00.0038 Onwards (For earlier versions see below) If you have embedded DataPA OpenAnalytics into your own software, it is preferable to not have to apply a license key to each individual machine when you deploy to your customer site. As such, yo9u may wish to apply the…
Read article →Developers › DevelopmentHow can I programmatically set my DataLocation in my application?
Applicable Versions: 5.00.0050 and above The DataLocation determines where DataPA looks for the file DataPASetup.dat, that contains the definitions for systems, subjects and links. The DataLocation is accessed when the ClientConfig object is initialised, so any changes must be made before the…
Read article →Developers › DevelopmentHow can I publish a dashboard to DataPA Enterprise using the API
Applicable Versions: 5.00.0050 onwards The ManagedDashboard class contains a Publish method that allows you to publish dashboards to a DataPA Enterprise server. The first argument of the Publish method requires a ClientConfig object that defines the location of the server and any licensing or…
Read article →Administration › InstallationHow can I run the DataPA installation silently?
Applicable Versions: All The DataPA installation package is an InstallShield Basic MSI package. As such, you can run it silently from a command line or batch file using the following command: setup.exe /s /v""/qn"" where s is for silent v is to pass parameters to the Microsoft installer process…
Read article →End Users › GeneralHow can I set the colour of a field in the DataPA Report Designer using script?
Sometimes you might want to highlight a field on your report in a different colour depending on a particular condition. In the example below we are adding script to the report Detail section on the BeforePrint event. This script will highlight the CustomerName field in RED if the Balance field…
Read article →Developers › DevelopmentHow can I set the default connection programatically in my application?
Applicable Versions: 5.00.0050 and above It is possible to access all the various properties of the DataPA System elements (Systems and their Connections) using a new API class added in DataPA OpenAnalytics 5.00.0050. This is called the QueryEngine and it is documented here. It is possible to…
Read article →Administration › Client AdministrationHow can I turn off the automatic update functionality for DataPA for every user on a machine?
Applicable Versions: 3.00.0001 Onwards DataPA's automatic update information can be turned off by default for all users of a machine (users can still turn it back on for themselves if they have access to the security screen). Follow the steps below to turned off autoamatic updates by default.…
Read article →Developers › DevelopmentHow can I use the new REST web service API to maintain SQL based Subjects in DataPA Enterprise?
Applicable Versions: 5.50.0102 and above As of DataPA V5.5 (5.50.0102) it is possible to use an REST web service API call to DataPA to create and maintain SQL based Subjects in DataPA as well as ODBC based Systems. IMPORTING SQL SYSTEMS The table below shows the details of the web service call…
Read article →Administration › InstallationHow can I white label the client applications
See Can I change the images and text shown by the DataPA client applications?
Read article →Developers › DevelopmentHow do a retrieve information on the content published to DataPA Enterprise using the API?
Applicable Versions: 5.00.0038 Onwards The ClientConfig object exposes the GetPublishedContent method that returns a PublishedContentCollection object containing a PublishedContent object for each report, query or dashboard published to a particular category. The PublishedContent object contains…
Read article →End Users › GeneralHow do I access the data grid right-click menu on an iPad or other tablet?
Applicable Versions: 6.0 onwards If you are using a touch device such as an iPad or other tablet, you can access the right-click menu (for such things as exporting, and allowing groups and summaries) by double-tapping anywhere on the grid. For grids with drilldowns, it may be best to tap on the…
Read article →End Users › GeneralHow do I access the data grid right-click menu on a touch device?
See How do I access the data grid right-click menu on an iPad or other tablet?
Read article →Administration › SetupHow do I access to the OpenEdge VST's with DataPA OpenAnalytics?
Applicable Versions: 5.50.0026 Onwards The OpenEdge VST’s offer insights into the physical storage, performance, memory usage and user activity of the database. However, they are not by default exposed to DataPA OpenAnalytics. To expose the VST's to DataPA OpenAnalytics, follow these steps; Add…
Read article →End Users › GeneralHow do I allow Grouping in grids on an iPad or other tablet?
See How do I access the data grid right-click menu on an iPad or other tablet?
Read article →End Users › GeneralHow do I allow Summaries in grids on an iPad or other tablet?
See How do I access the data grid right-click menu on an iPad or other tablet?
Read article →Administration › SetupHow do I change the license applied to DataPA Enterprise when an existing license has already been applied?
Applicable Versions: 4.05.000 Onwards "When I open DataPA Enterprise in a web browser, I get the error 'No valid DataPA OpenAnalytics Enterprise license has been applied to this server';. How do I fix this?" describes how to apply a license to a new installation of DataPA Enterprise. However in…
Read article →Administration › Server AdministrationHow 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 AdministrationHow 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 AdministrationHow 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 AdministrationHow 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 →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗