[]
v7.0
(Showing Draft Content)

Connect to MongoDB

To create a MongoDB data source in Wyn Enterprise, follow these steps.

  1. On the Resource Portal, navigate to Create (+) > Create Data Source.

  2. Select MongoDB in the data source list on the left or in the icon view on the right.

  3. Fill in the database configuration information for the selected data source.

Field Description
Name* The name for the data source that you want to specify.
Server* A server name or address.
Port A port number.
User* A user name to connect to the MongoDB database.
Password* A password of the MongoDB user.
Database* Enter the server MongoDB instance name.
Use Configuration String (Advanced) Use this option to connect to the data provider through a connection string. The format of the connection string is:Server= myServer; Port=myPort; Database=myDB; User=myUser; Password=myPassword; SIP=SchemaInferPolicy; Use Cache=True; Timeout=180; where SIP, Use Cache, and Timeout are optional parameters.-SIP: Indicates that the data type of this column is inferred from the data in the first few rows, the default is 0.
-Use Cache: The default value is true, which means that the result of this statement will be cached at the second level.
-Timeout: Timeout exit time, the default value is 180 seconds.
In addition, you can use the user context attribute in the string to filter data, in the format "@" such as "@". See User Context for details.
Use Table/Field Name Mapping If you check this option, you can either import a CSV file or manually enter the display names for the required tables or fields in the Mapping dialog. For more information on mapping table and column names, visit this topic.

* Required fields

  1. Click Create after the successful connection.

    You can view the added data source in the Categories tab of the Resource Portal.