Boolean determining if simple names should be used for the schema, table and column names.

Data Type

bool

Default Value

false

Remarks

Microsoft Dynamics 365 Business Central The company names or table/column names can use special characters in names that are normally not allowed in standard databases. UseSimpleNames makes the connector easier to use with traditional database tools.

Setting UseSimpleNames to true will simplify the names of schemas, tables and columns returned. It will enforce a naming scheme such that only alphanumeric characters and the underscore are valid for the displayed schema, tables and columns names. Any nonalphanumeric characters will be converted to an underscore. When setting this property to true, please make sure to query sys_schemas to pick up the simplified company name in SchemaName column before restricting your other connections to a single company using the Company connection property.