MongoDB

MongoDB

Creating MongoDB Dataset

To create a MongoDB dataset, follow the steps given below.

  1. On the home page, click the Create icon ( 
    ). The Product Selection page is displayed.
  2. Hover over the Data Connect tile and click Create Dataset.
    The following figure shows the Product Selection page.


  3. The Connect page for choosing your dataset type is displayed.
    From the NoSQL options, select MongoDB.
    The following figure shows NoSQL options.


    The Create MongoDB Dataset page is displayed.

  4. Enter a suitable Name for the Dataset.
  5. In the Connection Parameter section, there is a type dropdown having two options: standard, clustered
    1. After selecting standard option configure as following:
    -- Host     (IP address of the server where your database resides)
    -- Port (for the localhost on which the SQL database service is available)
    -- Username (of the account authorized to access the database)
    -- Password (for the account)
    -- Database (Name to access Collections)
    -- Authentication Database (Name to access Collections)
    2. After selecting standard option configure as following:
    -- Host (IP address of the server where your database resides)
    -- Username (of the account authorized to access the database)
    -- Password (for the account)
    -- Database (Name to access Collections)
    -- Authentication Database (Name to access Collections)
  6. If the collection contains JSON data files that contain multiple data blocks of different sizes, enable the ‘Max Level’ checkbox and enter the number of levels you want to expand to view nested data.
  7. Click Test Connection. The message "Database Connection Successful" is displayed in green if the parameters are accurate. After a successful connection, the collections dropdown is populated with a list of available collections.
  8. From the Select Collections dropdown, select the required collection(s) and click Done.
  9. To add a custom query to select data from the collections, click Add Custom Query. Add Custom Query screen is displayed. Refer to Adding A Custom Query for details.
  10. Click Create. The MongoDB dataset is created in Rubiscape and is available for use in your workbooks and pipelines.

Notes:

  • You can change the port before making a connection.
  • You can select multiple collections from the available options in the Select Collections dropdown.
  • Enabling the "Disable Cache" option allows you to create a dataset without generating a dataset cache.
  • When you select to "Disable Cache", the dashboard will not offer the "Enable Direct Query" option. For more information, please refer to the "Enable Direct Query" document.

    • Related Articles

    • Adding A Custom Query

      To add a Custom Query while creating a dataset, follow the steps given below. At the product selection page click on create dataset under Data Connect. Then Select any dataset Under RDBMS Click Add Custom Query on selected dataset. Then Add Custom ...

    • ODBC

      Creating ODBC Dataset To create any RDBMS or Non-RDBMS Dataset using ODBC, follow the steps 1 and 2 given in Creating SQL Dataset . The following figure shows the Product Selection page. The Data Connect page for choosing your dataset type is ...

    • Understanding the RubiThings Homepage

      The RubiThings home page is the default page assigned to you to visualize the overall activity occurring in your workspace. When you log in for the first time, the home page canvas is blank. That's because you have not configured any "Thing." You see ...