Show Sidebar Hide Sidebar

Setup the Database Connector on a Personal Computer

Setup database connections using Plotly's Database Connector

Step 1

Get To Know The Connector

The Plotly Database Connector is an open source web server and application that provides an interface between the Plotly Chart Creator and your databases and datastores.

Plotly Chart Creator makes HTTP requests directly to the Database Connector from the web browser. The Database Connector listens for these requests and makes queries to your configured databases or datastores.

Step 2

Download the App

If you haven't yet, download the Plotly Database Connector from this web page to get started! Upon clicking on the download button for either Mac or Windows distribution, a file should be added to your Downloads folder.

Step 3

Install the App (Windows)

Visit your Downloads folder. If you are using a Windows machine (Mac instuctions will follow), double click on the application executable.

Double click on the application. Your application will start to install itself. Note that some security settings may require you to install the application as an Administrator (right click and choose the administrator option to do so). The installation process may take up to several minutes.

Once installed, a desktop icon will be created on your desktop. Double click on it to open the application.

Step 4

Install the App (Mac)

Visit your Downloads folder. If you are using a Mac machine (Windows instuctions are in the previous section), double click on the application installer DMG file.

Drag the Plotly Database Connector icon into the Applications folder when prompted.

Once installed, a desktop icon will be created in your applications folder. Double click on it to open the application. Note that some security settings may require you to open the application as an Administrator (right click and choose the administrator option to do so). The installation process may take up to several minutes.

Step 5

Setup connections to your databases

The application will open and you can now setup connections to your databases. For more specific guidance, visit the tutorial for your database visit our full list that includes MySQL, MS SQL, PostgreSQL, MariaDB, Redshift, Apache Drill and Parquet files, S3, Elasticsearch or request a new one if you do not see what you want.

Step 6

Additional information

The Plotly Database Connector stores the credentials to your databases. It can also run queries on a schedule (see tutorial). The Plotly Database Connector will save the results of the queries to user accounts in the Plotly On-Premise server through the Plotly Grids API.

If you would like to run the Plotly Database Connector on a separate server, then you can run it headlessly from the command line (more information).

Still need help?
Contact Us

For guaranteed 24 hour response turnarounds, upgrade to our Premium or Enterprise plans.