Setup Guide


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

  2. Enter Cluster Endpoint as Server (e.g. "cluster-name".cluster-xxxxxxxxxxxx."region"

  3. Enter the port number for your primary node

  4. Enter the user detail

  5. Enter the password for the user you entered previously

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

    • SSH Server

    • SSH Port

    • SSH User

  7. If you have disabled SSL/TLS on your database, uncheck the Require TLS

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

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

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

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


Please make sure the user has access to the below actions

  • listDatabases

  • listCollections

Last updated