SQL Server connector
Overview
Microsoft SQL Server is a relational database management system widely used in enterprise environments for transaction processing, analytics, and business intelligence.
The SQL Server connector allows you to read, write, and synchronize data from your SQL Server database directly within Zoho Creator, without exposing it to the public internet. Connectivity is handled securely through DataBridge, a lightweight agent installed inside your network.
Meta Information
|
Connector
|
SQL Server
|
|
Default port
|
1433 (configurable)
|
|
Data centers
|
US, EU, IN, AU, CA, SA, and UAE
|
|
Applicable for
|
C6
|
|
Website
|
|
|
Privacy policy
|
|
|
Hosting support
|
Local / On-premise server
|
|
Categories
|
Database Management
|
Setting up SQL Server connectors
To connect Zoho Creator with your SQL Server database, follow the steps given below:
- In Zoho Creator, go to Operations -> DataBridge. From the list displayed, select the operating system and version that matches your host machine (for example, macOS - 64 bit). The DataBridge package will be downloaded as a zip file.
Note: If DataBridge is already installed and running on this machine, skip to Step 3. - Install DataBridge on the host machine where your SQL Server database is accessible. Once installed, start DataBridge.
- With DataBridge running, you're ready to connect SQL Server to Zoho Creator. In Zoho Creator, go to Operations -> DataBridge and confirm that DataBridge shows a status of Active.
- Once DataBridge is active, click Add Connection and select the SQL Server connector.
- In the Add Connection panel, the DataBridge is automatically selected. Fill in the remaining details and click Create and Authorize.
- When the Link Account popup appears, provide the following details: username, password, host, port, and database name. Click Authorize to complete the connection.
For detailed instructions, see Configuring DataBridge help doc.
Where this connector can be used
Data Sources
SQL Server data is accessible in Creator through integration forms, integration fields, and integration reports. The table below shows supported components by module.
|
Module
|
Integration Field
|
Integration Form
|
Integration Report
|
|
Records
|
✓
|
✓
|
✓
|