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 MinIO.
In the next tab, open your MinIO URL to get the database details.
Enter the credentials as username and password
After login, you will be redirected to the object browser of Minio
Now go to the bucket section and create a bucket.
Give a name, for example, minbucket (in my case).
Now go to Access Keys and create access keys.
After clicking “Create access key,” you will see the Access and secret keys. Keep The secret key safe, as it only generates and sees once.
Now enter all the credentials
Select the format in which you want to save your data in your MinIO
This option enables you to select the format in which you want to save the data in MinIO
After Successful Sync, we can see in the bucket(min bucket in my case) a folder created by the same name as the profile name.
Going inside, we can see the folders by the same name as the objects that we synched are created.
Inside Object, we can see the data is saved in CSV/Parquet format.
Select the Batch size
Purge Old Data For a Clean Copy enabling this will clean the old data before performing the clean copy and adding new data to the bucket
Test connection once all the details are filled test the connection
Note This section will only be visible once CSV is selected in the “Save As Type”
