[]
v8.0
(Showing Draft Content)

Custom Table Using MongoDB

Wyn Enterprise now supports creating Custom Schemas using the Custom Table feature. Upon adding or editing Custom SQL Tables within dataset, schema configuration will be required.

Note: The existing data sources and datasets referencing MongoDB will continue to function as before.

To create a custom table using MongoDB, navigate to the Dataset Designer page and follow the below instructions.

  1. Click the + Add Custom SQL Table button at the bottom-left corner to access the Custom SQL Table popup.

    CustomMongo-DirectDatasetDesigner

  2. In the Custom SQL Table dialog, enter the name of the custom table, select the required data source, select the query type as Text, Native Query, or Stored Procedure enter the SQL query command, and click Next.

    CachedDataset-CustomSQLPopup

  3. For MongoDB data sources, you can execute Native Queries within both Direct Datasets and Dashed Datasets.

    CustomMongo-NativeQuery

  4. The schema editor will appear in the popup with query results where you can select one data type from 6 types of data types including Number, Text, Date, DateTime, Boolean, and Guid for a column. Click OK to finish.

    CachedDataset-schemaeditor


    The following are two limitations of using MongoDB when adding custom SQL tables;

    1. The MongoDB query schema specified within the dataset primarily affects the inference of the data type for the custom SQL table. However, the complete schema acquisition for the table still relies on inference from the initial N rows of data. This process cab be illustrated by the list of data sources located in the left panel of the dataset designer.

    2. By disregarding the current association with MongoDB in the cached model, you can start by creating a cached dataset using MongoDB. Afterwards, you can simply reference this dataset within the cached model.

    Note: The following operations cannot be performed in the schema editor,

    1. Rename table.

    2. Rename Column.

    3. Add Columns.

    4. Delete Columns

    5. Reorganize Columns.

  5. The new custom table is added under Custom Tables in the Data Sources and Datasets area of the Dataset Designer.

    CachedDataset-CustomTables