Access level: read
This connection lets you extract cube and dimension information from a LucaNet database.
The following connection parameters for the Lucanet Financial OLAP Server are required:
Connection settings
| Host | The host name (DNS name) or the IP address of the server on which the database is located. |
| Port | The TCP/IP port number used by the database. |
| User name | User name for the connection to the database. |
| Password | Password for the connection to the database. |
| Database | Name, schema, or instance of the relational database. |
| Virtual database | Name of the virtual database created in Lucanet BI-Integration. |
| SSL mode | verify: the certificate is verified. trust: the certificate is imported to the keystore if not yet available. off: no SSL used. |
The data extraction is done with the extract types dimension and cube. In case of cube, you have to specify every dimension with "Query Filters on Dimensions" (e.g. Dimension1 like …, Dimension2 like …, …).
Hierarchies extracted with dimension extracts are always flat and don't contain attributes.
For more information on Lucanet see: http://www.lucanet.com/
Updated March 15, 2024