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 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 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.