Connecting to NoSQL

The supported NoSQL database types are:
  • Couchbase
  • MongoDB
Connect to the Hadoop system to use the stages, such as Read from Hadoop Sequence File, Write to Hadoop Sequence File, Read From File, Write to File, Read From XML, Write to XML, Read From Hive File, Write to Hive File, and Read from HL7 File, in Spectrum Enterprise Designer.
Attention: Spectrum Technology Platform does not support Hadoop 2.x for Kerberos on Windows platforms.
  • Query NoSQL DB
  • Read from NoSQL DB
  • Write to NoSQL DB
  1. Access the Connections page using one of these:
    Spectrum Management Console:
    Access Spectrum Management Console using the URL: http://server:port/management console, 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.
    Click Resources > Connections.
    Spectrum Discovery:
    Access Spectrum Discovery using the URL: http://server:port/discovery, 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.
    Click Connect.
  2. Click the Add connection button .
  3. In the Connection Name box, 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 Connection Type field, select any one of:
    • Couchbase
    • MongoDB
    Note: The MongoDB connection is available based on your current Spectrum version.
    Spectrum version Spectrum library Supported MongoDB version
    Spectrum 20.1 3.12.2 Upto 4.2

    Please refer MongoDB compatibility for details.

  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.