Build Data Integrations To Multiple, Disparate Data Sources

Data Integrations

“It’s in the ERP,” I remind you. A beat passes before I add “But the customer data is in Salesforce.”

A blank stare washes over your face while internally you’re having a silent moment of confession: I don’t want to deal with that.” You didn’t say it out loud, but that’s probably what you’re thinking.

Imagine you need to build a new form that fetches some data from an old ERP AND some data from Salesforce, pre-load that data into some fields, then let your users fill out the rest.

Sounds simple, but you know better.

Maybe that’s not an exact scenario you’ve faced, or will face, but you can imagine something similar.

Maybe you’ve been using home-brewed forms that you or your team built from scratch. Maybe you’ve been using a drag and drop form builder, which is great, because that sped up the process of building forms quite a bit.

There’s just one problem.

All your forms are server-side rendered.

I’m NOT talking about modern server-side rendering where content is pre-rendered before delivery. I’m talking about old school, server-dependent, server-rendered—because that ERP you’re dealing with is old.

And as you know, each server is its own sandbox—separate and walled off from other systems.

In order to make this new form pull data from both the ERP and Salesforce, you’re going to have to set up a VPC pairing, open up some endpoints, and deal with a bunch of other complexities to make it work.

Or it may not even be possible if your organization has blocked all outgoing traffic due to security considerations.

Form Bridges In The Browser

Browsers have easy access to all the systems. So whatever you can fetch from the browser instead of directly from one server to another is infinitely less complex—it already has API access to the systems.

You may have already considered this and you may be thinking about the client-side authentication piece that’s required—we did too. does it already—built in.

Because our forms are client-rendered, the forms themselves can fetch the data in both systems, from the browser, and pre-load that data into the fields.

Then when the user submits the form, you have a new document of record that’s stored in and integrates with multiple data sources.

And we know authentication can be a hassle, which is why makes it as easy as possible to integrate with your existing provider using SAML, OAuth, or custom JWT Tokens, as well as others.

No need for complex configurations, opening up endpoints, or dealing with extra security considerations.

The Ultimate Easy-Button To Build Data Integrations Is Through Client-Rendered Forms.

Published by Wizard is a zero-trust, data governance strategy platform, embedded in your environment, that enables you to build business process workflow applications or anything that uses forms with lightning bolt speed. is unique in its reach to the application layer regarding governance because we acknowledge forms are the primary entry point into everything data related. Forms are the UI, forms are the data model, and forms are the API model.

LighthouseHQ Case Study: Digital Transformation
Get Answers

Need More Answers?

Ask and we'll get back with you in 1 business day.

Contact Us

Send us a message to contact support or ask a question.

Schedule a meeting

Open Source Platform

Read our FAQ to find out what exactly is Open Source

View the Platform Documentation

View the API Documentation

View the Open Source Code

Learn More

Learn How It Works

Read the Release Notes

Discover Industries that use

Read our Blog