One of the strengths of the CData JDBC Driver for MarkLogic is its cross-platform support, enabling integration with major BI tools. Follow the procedure below to access MarkLogic data in KNIME and to create a chart from MarkLogic data using the report designer.
Define a New JDBC Connection to MarkLogic Data
- If you have not already done so, install the Report Designer extension: Click File -> Install KNIME Extensions, and filter on "Report".
- In a new workflow, click File -> Preferences and expand the KNIME -> Database Driver nodes to add cdata.jdbc.marklogic.jar. The driver JAR is located in the lib subfolder of the installation directory.
-
In the Node Repository view, expand the Database node and drag a Database Reader onto the workflow editor.
-
Double-click the Database Reader and set the following properties:
- Database Driver: In the menu, select the CData JDBC driver.
- Database URL: Enter the connection properties. The JDBC URL begins with jdbc:marklogic: and is followed by a semicolon-separated list of connection properties.
User、Password、および Server に、アカウントの認証情報と接続するサーバーのアドレスを設定します。また、REST Server Port を指定する必要があります。
A typical JDBC URL is below.
jdbc:marklogic:User='myusername';Password='mypassword';Server='http://marklogic';
- User Name: The username used to authenticate.
- Password: The password used to authenticate.
- SQL Statement: Enter an SQL query in the SQL Statement box or double-click a table. This article uses the query below to create a chart:
SELECT Name, TotalDue FROM Customer
-
Test the connection by clicking Fetch Metadata.
-
Connect the Database Reader to a Data to Report node to supply the dataset to a range of data visualization controls. Click Execute and then click Edit Report at the top of the workflow to open the report designer perspective.
-
You can now generate reports based on live data. To create a chart, drag the chart control from the palette to the report designer. In the resulting wizard, you can use the filtering and aggregation controls available in KNIME.
