| Available for | Roles | Super Admin |
| Permissions | • Manage Data Warehouse Sync integration | |
| Packages | Advanced Analytics add-on |
This article provides a step-by-step guide for transferring your data, along with a tutorial on using PowerBI. Once you’ve set up a connection between DWS and your business intelligence tool (or any other data storage system), you can begin copying your data.
In this article
Establishing a connection
In order to copy data using Data Warehouse Sync (DWS), you will need to establish a connection to your data via AWS Athena. You can connect to AWS Athena via DBeaver or ODBC. Read more about these options here:
Once you have established a connection between DWS and your business intelligence tool (or other data storage unit) you are ready to start copying your data. The specifics of this process will vary depending on your tool or data storage unit, but will generally follow these steps:
- Configure your BI tool (or data storage unit) to use the ODBC connection and DSN you set up
- Select which tables you want to copy
- Execute the copy and store your data
- Set up a recurring task to copy data on a regular cadence (optional)
Note that data provided via DWS is refreshed once every 24 hours.
Copying data with PowerBI
- Ensure that your download will not get throttled by Athena
- Open PowerBI and navigate to File > Options and settings > Options; click on Data Load under the 'Current File' section
- Uncheck the option to 'Enable parallel loading of tables' and click OK
- Click on Get Data in the 'Home' menu
- Select the ODBC connector
- Select the DSN that you set up earlier (refer to our ODBC help article for more information)
- Select 'Default or Custom' and click Connect; you may leave the 'Credential connection string properties' field blank; you do not need to enter your credentials again
- When the information loads, expand the file hierarchy until you expand the list of tables; select the tables you are interested in downloading by ticking the boxes next to the name of the table and click Load
You have executed your first download using Data Warehouse Sync. You can now manipulate the tables and edit table relationships to suit your specific reporting needs as well as build custom views and integrate your Lever data with other data sources.