Connecting to NoSQL

The supported NoSQL database types are:
  • Couchbase
  • MongoDB

You can create flows in Enterprise Designer using these stages of Enterprise Big Data module to read data from, and write data to this database.

  • Query NoSQL DB
  • Read from NoSQL DB
  • Write to NoSQL DB
  1. Access the Data Sources page using one of these modules:
    Management Console:
    Access Management Console using the URL: http://server:port/managementconsole, where server is the server name or IP address of your Spectrum™ Technology Platform server and port is the HTTP port used by Spectrum™ Technology Platform.
    Note: By default, the HTTP port is 8080.
    Go to Resources > Data Sources.
    Metadata Insights:
    Access Metadata Insights using the URL: http://server:port/metadata-insights, where server is the server name or IP address of your Spectrum™ Technology Platform server and port is the HTTP port used by Spectrum™ Technology Platform.
    Note: By default, the HTTP port is 8080.
    Go to Data Sources.
  2. Click the Add button .
  3. In the Name field, enter a name for the connection. The name can be anything you choose.
    Note: Once you save a connection you cannot change the name.
  4. In the Type field, select any one of:
    • Couchbase
    • MongoDB
  5. Specify the Host, Port, Database, Username and Password of the specific NoSQL database you wish to access.
  6. Click Test to check that the connection to the database is successful.
  7. Click OK.