- Getting Started
- Administration Guide
-
User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
-
Data Governance and Modeling
- Data Binding Concepts
- Introduction to Data Sources
- Introduction to Data Model
- Introduction to Direct Query Model
- Introduction to Cached Model
- Introduction to Datasets
- How To
- Secure Data Management
- Working with Resources
- Working with Reports
- Working with Dashboards
- View and Manage Documents
- Understanding Wyn Analytical Expressions
- Section 508 Compliance
- Subscribe to RSS Feed for Wyn Builds Site
- Developer Guide
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 (Cached Dataset) page and follow the below instructions.
Click the + Add Custom SQL Table button at the bottom-left corner to access the Custom SQL Table popup.
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.
For MongoDB data sources, you can execute Native Queries within both direct and cached Datasets.
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.
The following are two limitations of using MongoDB when adding custom SQL tables;
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.
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,
Rename table.
Rename Column.
Add Columns.
Delete Columns
Reorganize Columns.
The new custom table is added under Custom Tables in the Data Sources and Datasets area of the Dataset Designer.
