How do I connect Zoho Creator to Salesforce or external databases?
Use Zoho Creator connections for Salesforce and other cloud apps, which handle authentication so Deluge scripts can read and write records. For external databases, expose the data through a REST API and call it from Creator, or sync with Zoho Flow. Creator does not connect directly to most databases over SQL, so plan an API layer for on-premise systems.
Zoho CRM setup from USD 500Fixed price in writing. Every service has a published price.
- Registered Zoho partner
- Calls in your business hours
- 30 days of free fixes
Creator has built-in connections for many services, including Salesforce. You create the connection once, choose the scopes, and then use Deluge to fetch or update Salesforce records from workflows, buttons or schedules. Keep the number of calls in mind, as both Zoho and Salesforce apply API limits.
Databases are different. Creator works best when the database sits behind a small API that Creator calls with invokeUrl. For simpler cases, Zoho Flow can move data between Creator and many tools without code. For reporting rather than live use, Zoho Analytics can import from databases and cloud apps, and Creator can embed those reports.
Decide whether you need live data or a scheduled copy. Live calls give fresh data but slower screens and more failure points. A scheduled sync into Creator is faster for users but can be minutes behind. Log every integration error to a Creator form so failures are visible.
Key points
- Create a Salesforce connection in Creator with the needed scopes.
- Write Deluge functions to read or write Salesforce records.
- Put an API in front of any external database.
- Choose live calls or a scheduled sync per use case.
- Log errors to a form and review them weekly.
Common questions
Can Creator query my SQL Server directly?
Not as a direct SQL connection in most setups. Expose the data through an API or use a sync tool.
Does Zoho Flow work with Salesforce?
Yes. Zoho Flow has a Salesforce connector for simple triggers and actions.
Sources and further reading
Get a free Zoho audit
30 minutes with a senior Zoho consultant. No obligation.
- Fixed price in writing
- Paid by milestone
- 30 days of free fixes after go-live
- Registered Zoho partner
Written by Flowpeak, a Zoho implementation partner. Zoho pricing and features change, so confirm current details on the official Zoho site. Free checklists | Ask us a question