MongoDB

Steps

  1. Enter a Connection Name, excluding whitespace and special characters

  2. Enter the hostname or IP address of the MongoDB REST server. For replica sets, choose one of the servers in the replica set.

  3. Enter the port number for the server.

  4. Enter Replica Set server details (Comma separated) if applicable. The Server and Replica Set together specify all instances in the MongoDB replica set. Specify both the server name and port in ReplicaSet. For example: mycluster0-shard-00-01.mongodb.net:27017,mycluster0-shard-00-02.mongodb.net:27017

  5. Would you like to read from Slave (By default it is true). This allows reading from secondary (slave) servers in the replica set.

  6. Enter the username

  7. Enter the password for the user

  8. If you selected Connect via an SSH, provide the following information

    • SSH Server

    • SSH Port

    • SSH User

  9. By default, the Flatten object properties into columns of their own is checked. If your document fields keep changing frequently please uncheck this option otherwise you might see an Invalid column name error randomly as that column might not be available when we run the job next time.

  10. By default, the Type Detection Method will be 'RowScan' where we will scan 100 rows to heuristically determine the data type and columns. If you have mixed types of data(e.g. date and string or numeric in one column) then select 'None', It will return all columns as the string type. Note: You can only use replace mode if you are selecting 'None' as a Type Detection Method.

  11. By default, the Rows to scan to look for the columns available will be 100 rows to heuristically determine the data type and columns. If you don't see your field in the column list you can increase the value. Setting a high value may decrease performance. Setting a low value may prevent the data type from being determined properly.

  12. When you're happy with your settings, click Save -> Test -> Publish

Last updated