MongoDB

Steps
Enter a Connection Name, excluding whitespace and special characters
Enter the hostname or IP address of the MongoDB REST server. For replica sets, choose one of the servers in the replica set.
Enter the port number for the server.
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
Would you like to read from Slave (By default it is true). This allows reading from secondary (slave) servers in the replica set.
Enter the username
Enter the password for the user
If you selected Connect via an SSH, provide the following information
SSH Server
SSH Port
SSH User
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.
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.
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.
When you're happy with your settings, click Save -> Test -> Publish

Sources - Previous

Microsoft SQL

Next - Sources

MySQL

Last modified 27d ago

Copy link