Overview

Uses a CData plugin

This algorithm allows you to connect to an existing mongodb instance allowing get, update, insert and delete operations using a simple SQL interface.

Configuration Settings

This algorithm requires configuration settings to work. You'll need:

• user/password which has access to your mongodb database
• your mongodb server host (eg; www.heresmymongo.com)
• your mongodb server port (optional, defaults to the mongo default of 27017.)
• the name of the specific mongodb database you plan to use

To Configure

to configure, gather the information necessary above, and make an API request like the following

{"user": ..., "password": ..., "database": ..., "server": ..., "port": ...}

Where port is optional

The response will return a data API similar to the following: data://.algo/zeryx/cdata_mongo/perm/config.json once that's done the algorithm will automatically find your configuration settings and use it for future requests. If you'd like to make a change please delete the file at that location and run the configuration steps again.

Usage

Input

Your SQL command, for example:

"SELECT ID FROM TEST"

will yield: ["(1)", "(2)", "(3)"]