Exporting data into Microsoft SQL Server or Snowflake
Microsoft SQL Server or Snowflake are often used by enterprises to bring together data from various sources for reporting purposes or for driving other apps and use cases.
DotAlign Cloud comes with a utility to export your DotAlign data set into SQL Server or Snowflake. To use it, please follow these steps:
- Download, unblock and unzip the file into a folder on your machine
- When you unzip the download, you will see 3 files
- da_profile_sync.exe – This syncs contacts and companies and associated information.
- da_interactions_sync.exe – This syncs email messages and meetings with participants.
- sample_env_file.txt - This file is a sample of how your environment file should look like. It has all the properties that are needed for the sync utilities to work.
- Rename the sample_env_file.txt to
.envin the same folder. Please note the
.at the start of the file name. This file contains the sensitive information that the utility needs, for example the credentials to use to hit the DotAlign Cloud API and the credentials to use for the SQL Server. The following specific properties need to be specified in the .env file
SNOWFLAKE_LOGIN_AS_ROLE="" // defaults to "SYSADMIN"
- Now you can run the sync utilities. You can run the command with a
--helpoption to get help with with the parameters.
Please note that the parameters are case sensitive
However, the only parameter you are required to specify is the
--teamNumber parameter. This will tell the exporter which team's data to fetch from DotAlign Cloud. You can find the team number to use by looking at your DotAlign Cloud deployment and finding the team number there. The image below illustrates where you can find the team number on the DotAlign Cloud app.
Following is a sample run of the export utility.
As you can see it connects to the DotAlign Cloud API and fetches a batch of data, transforms it, and then connects to the SQL Server or Snowflake as configured, and writes the transformed data into the appropriate tables.
Questions? Please feel free to reach out to firstname.lastname@example.org.