Documentation

Switch Data Storage Location

 

Once you have connected your database, you can choose to edit some parameters as well as to change the storage location of your data if necessary. The following steps demonstrate how to change the storage location of your database from remote connection to our data warehouse or back from the data warehouse to a remote connection.

 

Switch from remote connection to data warehouse

 

1) Go to Settings.

 

2) Search for your database and click on Edit in the lower left corner of the data source widget.

 

remote-to-data-warehouse

 

3) In Setup, change the data storage location from remote to data warehouse by selecting the option Transfer data to our data warehouse.

 

4) Click on Save. A notification appears. Insert your login password and click on Ok if you estimate that the extraction will not interfere with other users. This will start the extraction process and you will be redirected to the data transfer page. Once the extraction was successful you will get notified.

 

Caution: Moving the data storage to data warehouse might take a while and users won’t be able to use datapine during the extraction. You might want to check with your organization users which time is best to move the storage location of your data.

 

Switch from data warehouse to remote connection

 

1) Click on Settings.

 

2) In the data sources tab, look for your database and click on Edit in the lower left corner of the data source widget.

 

data-warehouse-to-remote

 

3) In Setup, switch the data storage location from data warehouse to remote connection by selecting the option No data storage (connect remotely).

 

4) Click on Save. A notification will appear and ask you to authorize this process. Insert your login password and click on Ok. Once the setup of the remote connection was successful you will get notified. 

 

Caution: Please note that a switch from data warehouse to remote connection might have a significant impact on loading performance and you should make sure that your server can handle these requests. However, we always recommend to never setup a remote connection to a production server as this might lead to severe performance issues.