DBSync Cloud Replication (Salesforce with Azure Synapse)
Azure Synapse Database details in DBSync Replication Profile
Go to the database section and select database type as Azure Data Lake Gen2
The credential you will get from the Azure portal:
Just log in to portal.azure.com and create a storage account:
Get inside of the storage account(demodbsynctesting in my case
Now scroll down the left panel and search for Access keys in the Security+Networking section.
Click on the Show button and Copy the Storage Key.
Now copy the storage account name and key copy the database section in the database section:
After the Sync goes on the container in the Azure portal, A folder is created with the name same as your profile name.
Click on it, and all the objects you sync, those folders get created (Account in my case)
The data is saved in CSV format.
