BackPrevious Page Next PageNext

Setting Up a MongoDB Connection

To set up a MongoDB connection to connect a JReport catalog to a MongoDB data source, follow the steps below:

  1. Create a catalog or open a catalog, then in the Catalog Manager, right-click the node of a data source and select New MongoDB Connection from the shortcut menu.

    If you want to set up the connection in a new data source in the catalog, select any of the existing catalog data sources, click New Data Source on the Catalog Manager toolbar, then in the New Data source dialog, specify the name of the data source, select the MongoDB connection type and click OK.

    The MongoDB Connection Wizard appears.

    MongoDB Connection Wizard - MongoDB Connection Information

  2. In the MongoDB Connection Information screen, type in the host and port of the MongoDB server, and also the user ID and password to connect to the MongoDB server. Click Next.
  3. In the Connection Options screen, click Add button to add a line for specifying the conditional replica set member for the MongoDB connection. If necessary, click Add button to add a new replica set member. Click Remove button to remove a selected replica set member. Then specify the options for the connection. Click Next.

    MongoDB Connection Wizard - Connection Options

  4. In the Add Database screen (this screen will be displayed only when you have no right to access all the databases in the MongoDB data source), click Add button to add a line for specifying the databases you can access in the MongoDB data source. If necessary, click Add button to add a new database. Click Remove button to remove a selected database. Click Next.

    MongoDB Connection Wizard - Add Database

  5. In the Add Schema screen, add the collection schemas that will be transformed to relational schemas into the catalog. Click Next.

    MongoDB Connection Wizard - Add Schema

  6. In the Add Table screen, add the required tables that are transformed from the relational schemas.

    MongoDB Connection Wizard - Add Table

  7. Click Finish to confirm the transformed result and finalize the transformation process.

Note: When setting up the connection via SSL, you need to import the SSL certificate into the default JKS, and use the -D parameter to specify the system parameter in the file JRServer.bat in <server_install_root>\server\bin (the MongoDB Java driver mongo-java-driver-3.4.0.jar is already within JReport). Then add ssl=true in the Options box of the Connection Options screen of the MongoDB Connection Wizard.

BackPrevious Page Next PageNext