To connect over TLS/SSL, prefix the Server value with ' Note: TLS/SSL and client authentication must be enabled The data provider uses X-Pack Security for TLS/SSL and authentication. To use PKI, set the SSLClientCert, SSLClientCertType, SSLClientCertSubject, and SSLClientCertPassword properties. To authenticate, set the User and Password properties, PKI (public key infrastructure) properties, or both. Set the Server and Port connection properties to connect. This starts with jdbc:elasticsearch: and is followed by a semicolon-separated list of connection properties. In the resulting dialog, configure the connection properties as shown below.Ĭustom Connection URL property: Enter the JDBC URL. Run the report-designer.bat file in the \Report-Designer\ folder to open the Report-Designer UI.Ĭreate a new data source with the driver by clicking Data -> Add Data Source -> Advanced -> JDBC (Custom) and then creating a new Elasticsearch connection.Copy the JAR file of the driver, located in the lib subfolder of the installation directory, to the \Report-Designer\lib\jdbc\ folder in the Pentaho directory.This article shows how to connect to Elasticsearch data as a JDBC data source and publish reports based on Elasticsearch data in Pentaho. The CData JDBC Driver for Elasticsearch data enables access to live data from dashboards and reports.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |