How can we help?
Find a clear answer, or a friendly human.
Explore the knowledge base
32 articlesAfter doing a DataPA update I cannot view my form which uses a DataPA control and receive the error ‘Visual Designer cannot load this class’. How do I fix this?
When an update has been done to DataPA the assemblies which hold the DataPA .NET controls will likely have had their version numbers incremented and this causes Progress Architect to believe that the DataPA controls are no longer available. Architect doesn’t handle the upgrade of these controls…
Read article →Developers › DevelopmentCan I save and store reports in my Progress Database?
Applicable Versions: 3.05.0014 onwards Reports can be stored in a Progress table like any other binary object using the RAW data type. The example code below uses a temp-table to store and load the report. This temp table could be passed to a server if required, and stored in a database table.…
Read article →Developers › DevelopmentCan I use DataPA with a direct database connection?
Applicable Versions: 3.02 Onwards From version 3.02 DataPA can now use a direct database connection rather than having to access the data through the Progress AppServer. This is only possible where the DataPA has been embedded into a Progress GUI client which already has established database…
Read article →Developers › DevelopmentCannot add the DataPA Reports control to a Visual Studio 2005/2008 Forms project.
Applicable Versions: 2.05.0257 and previous Symptoms When you try to add a DataPA Reports object to a windows form you get the error message ""Failed to import the ActiveX Control. Please ensure it is properly registered"". When you try build an existing windows forms project with a DataPA…
Read article →Developers › DevelopmentControlling the export process using the API
Unfortunately it is not possible to configure the settings of this export screen using the com object. That said, you can manually manage the export process rather than using this screen. For instance, if you want to export the report to a PDF file, where the export file name is contained in the…
Read article →Developers › DevelopmentEmbedded dashboard only shows login screen
Please see HTTPS is required for embedded dashboards
Read article →Developers › DevelopmentHow can I get the URL for a dashboard, report or query published to DataPA Enterprise so I can use it in my own web application?
Applicable Versions: 4.05.0050 and above You may wish to embed dashboards, reports and queries into your own webspeed or web application. Follow these steps to retrieve the URL for the dashboard, report or query you wish to embed; Open the DataPA Enterprise Dashboard client application. From the…
Read article →Developers › DevelopmentHow 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 →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 →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 →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 →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 →Developers › DevelopmentHow do I create an open API query?
Applicable Versions: 6.00.0016 and above An open API query allows you to create your own bespoke assemblies to gather data from anywhere. For example, consider the scenario where I want to use current currency exchange rates in my dashboard. This article on codeproject gives code on how pull…
Read article →Developers › DevelopmentHow do I manage the DataPA Application object in my application to reduce the calls to the server and improve performance
Applicable Versions: 2.01.0152 and above When the application object is created it runs through an initialisation routine. Depending on your configuration, this routine may involve several AppServer calls and as such can be costly in terms of performance if repeated unnecessarily. As such, it is…
Read article →Developers › DevelopmentHow do I pass login credentials to an embedded Dashboard using autoLogin?
Applicable to version 6.00.0210 and upwards. The most secure way to pass credentials when viewing a dashboard embedded in your application, is to pass an authorisation token. This token is short-lived, and does not expose any login credentials. First, make an HTTP POST request to…
Read article →Developers › DevelopmentHow do I prevent DataPA OpenAnalytics showing the automatic update screen when it is embedded in our software?
Applicable Versions: 4.05.0001 Onwards If you have embedded DataPA OpenAnalytics components into your application, it is likely you will wish to control when updates are applied and prevent the automatic update screen showing when DataPA issues an update for the software. Rather than having to…
Read article →Developers › DevelopmentHow do I to change the Enterprise Server Settings through a Progress program.
Applicable Versions: 5.00.0050 onwards The ServerSecurity settings, data is stored in a file on disk in the ProgramData folder on the server. We have an example program that stops the DataPA Enterprise Service, opens this file from disk, makes some changes before restarting the service. The…
Read article →Developers › DevelopmentHTTPS is required for embedded dashboards
To embed dashboards in another web page, HTTPS must be enabled for the Web Site relating to DataPA Enterprise in IIS. HTTPS is strongly recommended for all installations of DataPA Enterprise to protect your security credentials, and data. Futhermore, in 2020, changes began to emerge in browsers…
Read article →Developers › DevelopmentI am receiving Out-of memory error messages and other errors with large dashboards opened in the dashboard designer control embedded in my application. Is there anything I can do to improve this?
Applicable Versions: All In version 5.50.0072, we released a change to improve the handling of source data (the raw data returned by the query) in the dashboarddesigner control. Most objects on a dashboard will build their own partial summary data, and as such unless they are going to be edited…
Read article →Developers › DevelopmentIs it possible to control the display of dashboard tabs when embedding a dashboard into my application using DataPA Enterprise?
Applicable Versions: 4.05.0084 and above "How can I get the URL for a dashboard, report or query published to DataPA Enterprise so I can use it in my own web application?" describes how to obtain the URL to embed a dashboard rendered by DataPA Enterprise into your application. You may also want…
Read article →Still looking for an answer?
Ask our help assistant, or get in touch with the team.
Email support@support.helpdesk.inmydata.ai ↗