Rules and Guidelines for Using Virtual Tables
Consider the following rules and guidelines when you use virtual tables with MongoDB Connector:
- •If you want to import and use virtual tables in a task, you must set the following properties when you configure the MongoDB data source name on the Secure Agent machine:
On Windows:
- - Nested Column Separator: _
- - Virtual Key Column Separator: _
On Linux:
- - NestedColumnSeparator=_
- - VTKeyColumnSeparator=_
- •You cannot use MongoDB Connector to read or write column or table names that have more than 65 characters. When you create virtual tables in MongoDB, the ODBC driver appends the column names with the name of the array column. The driver also appends the container column names with the name of the contained array.