Syncing Salesforce to MS SQL without normalization in Airbyte

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is looking for a way to sync Salesforce to MS SQL without normalization in Airbyte. They are using the open-source version.


Question

So I’m trying to sync Salesforce to MS SQL, however I gather that normalization is no longer supported. Is there anyway around this? (I’m using Open source)


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["syncing", "salesforce", "ms-sql", "normalization", "open-source", "airbyte-connector"]
2

MSSQL has a new method, Dv2, that simplifies your data like normalization, but with fewer nested tables. If you need to explore nested objects, it’s best to create dbt models or views to extract that information. Let me know if this is useful.