Availability

SQL Server Connector configuration is an Enterprise feature available on request that requires a valid license purchased from Ninox or a certified partner.

How SQL Server Connectors work in relation to Ninox

SQL Server Connectors allow you to query and create tables in an external SQL Server database. In relation to Ninox, SQL Server Connectors help you connect your Private Cloud or On-Premises to an external relational database management system. Refer to SQL Server Connectors (external help page) for more info.

Implementation notes/limitations

1. Some Ninox functions may change in future versions.
2. Current Ninox functions for SQL only work on the server side.
3. Data streaming is currently not available in Ninox.
4. SQL commands with large data transfers may fail.
5. A dedicated log for SQL Server Connectors is currently not available in Ninox.

Security considerations/recommendations

1. Any user can run any SQL command in Ninox.
2. We recommend implementing security options on the SQL Server side.
3. We recommend setting up the login on the SQL Server side.

Supported use cases

SQL Server Connectors are particularly helpful in cases such as:

• You manage your production data in an SQL database and your CRM data in Ninox. For some reports you need to fetch a fitting, complex product ID from the production database.
• You manage your CRM data with Microsoft Dynamics Navision (which is based on an SQL database). You need specific data for your Ninox application. Instead of manually exporting .csv files and importing them to Ninox, you'd like transfer these files automatically.