#Zoho creator sql server data driver
#Zoho creator sql server data software
#Zoho creator sql server data password

Note that a value of 'localhost' in the datasrc input refers to the machine where SQL Server is running, so be careful when creating a linked server in Management Studio when not running on the same machine as SQL Server. provider: Enter 'SQLNCLI', for the SQL Server Native Client Provider.ĭatasrc: The host and port the service is running on, separated by a comma.

In addition to using the SQL Server Management Studio UI to create a linked server, you can use stored procedures.

#Zoho creator sql server data password

In the Security section, select the option to have the connection 'made using this security context' and enter the username and password of a user you created in the Users tab of the SQL Gateway.

Catalog: Enter the CData system DSN, CData ZohoCreator Sys.

Note that a value of 'localhost' in this input refers to the machine where SQL Server is running so be careful when creating a linked server in Management Studio when not running on the same machine as SQL Server. For example, SQL Server Native Client 11.0.ĭata Source: Enter the host and port the TDS remoting service is running on, separated by a comma.

Provider: Select the SQL Server Native Client Provider that corresponds to your version of SQL Server.

In the General section, click the Other Data Source option and enter the following information after naming the linked server:.

The New Linked Server dialog is displayed. In the Server Objects node, right-click Linked Servers and click New Linked Server.

In the Object Explorer, expand the node for the SQL Server database.

Open SQL Server Management Studio and connect to an instance of SQL Server.

You can use the UI in SQL Server Management Studio or call stored procedures.įollow the steps below to create a linked server from the Object Explorer. Create a Linked Server for Zoho Creator DataĪfter you have configured and started the daemon, create the linked server and connect. The TDS remoting service is a daemon process that listens for TDS requests from clients. See the SQL Gateway Overview for a guide to configure a TDS remoting service in the SQL Gateway UI. If you would prefer to use your own custom OAuth app, see the Help documentation.

The connector is already registered with Zoho Creator as an OAuth application. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

#Zoho creator sql server data driver

This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). You can then work with Zoho Creator data just as you would a linked SQL Server instance.Ĭonnect to Zoho Creator as an ODBC Data Source After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server.

#Zoho creator sql server data software

This presentation will go through the main data integration workflows and how Burns & McDonnell’s technical consultants used FME in collaboration with Safe Software and The City’s Citizen Help desk staff.You can use the SQL Gateway to configure a TDS (SQL Server) remoting service and set up a linked server for Zoho Creator data. This helps program staff efficiently and effectively respond to Citizens. Oracle Primavera Unifier is used for capital planning, project delivery, cost controlsįME is used to bring information together from separate systems allowing program staff to see where calls are in relation to work occurring or scheduled to occur in the program. Cityworks is used for asset and work order management. ArcGIS Online is used to publish maps and feature services providing access to information to program stakeholders. Zoho Analytics is used to show related citizens calls and how long the call takes to resolve. Zoho Desk is used to log and manage citizen calls with ticket tracking workflow. The Challenge: Multiple systems are in use in the Capital Program making it challenging to tie related information together. Program staff utilize Customer Relations Management (CRM) and Help Desk tools from Zoho to log issues and track resulting tickets. To help respond to citizen efficiently there was a need to quickly locate calls on a map in relation to project locations, existing work-orders, and city-owned wastewater assets Extending the reach of FME Data Integration and AutomationĪ mid-sized city in Louisiana was seeking to improve citizen engagement and reduce the amount of time that citizen issues were being addressed on a 12-year capital improvement program