| Note |
|---|
Please make sure that when installing/upgrading Apliqo UX you also select the option to install the Apliqo Server in order to be able to connect to SQL databases. |
...
source: configure type, odbc_src_name, tableArray and displayName
type: type of data source
odbc_src_name: name of the data source defined in ODBC (step 1 of the configuration)
tableArray: list the table names defined ODBC source that you want to have listed in the cube settings (can be more than one - need to be comma separated e.g. ["table1","table2"])
displayName: name that will be displayed in the Apliqo UX cube settings
...
| Panel | ||
|---|---|---|
| ||
Users have the ability to encrypt their usernames and passwords within the configuration settings. How to Use:
|
u: user name used to log into the SQL Database
p: password
encoded: true/false
Example:
| Code Block | ||
|---|---|---|
| ||
"source":[
{
"type":"odbc",
"odbc_src_name": 'EmployeeDB',
"tableArray":["Employees"],
"displayName": 'Employee Details',
"u":"QXBsaXFvVVhfVXNlcg==",
"p":"b3dld2R1aW0xMw==",
"encoded":"true"
},
], |
2.2 Repeat step 2.1 to add additional data sources
...