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 set the default connection (primary connection) programatically using the new API using the following Progress ABL code example:-
| DEFINE VARIABLE chClientConfig AS COM-HANDLE NO-UNDO. CREATE "DataPAClientConfig.ClientConfig" chClientConfig. chClientConfig:Initialise_2(). chClientConfig:SetupManager:Systems():Item("sports2000"):Connections:Item("localhost"):Primary = TRUE. chClientConfig:SetupManager:RefreshRecordsets(). RELEASE OBJECT chClientConfig NO-ERROR. |
Applicable Versions: 3.00.0001 to 5.00.0049
It is possible to set the default connection programatically using the following Progress ABL code example:-
| DEFINE VARIABLE chApplication AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chSports2000 AS COM-HANDLE NO-UNDO. CREATE "DataPA.Application" chApplication. chSports2000 = chApplication:Systems:Item (, "cName='sports2000'"). chSports2000:DefaultConnection = "localhost". RELEASE OBJECT chSports2000 NO-ERROR. RELEASE OBJECT chApplication NO-ERROR. |
This table below summarises the available properties on the System object that can be used to manage connections for that system:
Properties
| Property | Type | Description |
| Connections | Collection | Returns a collection object containing a list of PAConnectionDetails (see below) that detail the connections defined for the system. |
The PAConnectionDetails type holds details of a particular connection defined for a system. The following table lists the properties of the PAConnectionDetails Type.
| Property | Type | Description |
| Name | String | Indicates the name of the connection. |
| Primary | Logical | Indicates whether this is the default connection for the system. |
| Admin | Logical | Indicates whether this is the default administration connection for the system. |
| Host | String | Corresponds to the system's Host property |
| Service | String | Corresponds to the system's Service property |
| AppService | String | Corresponds to the system's AppService property |
| URL | String | Corresponds to the system's URL property |
| AppServerInfo | String | Corresponds to the system's AppServerInfo property |
| PromptUser | Logical | Corresponds to the system's PromptUser property |
| Direct | Logical | Corresponds to the system's Direct property |
| DynamicsSecurity | Logical | Corresponds to the system's DynamicsSecurity property |