Connect to Dropbox with ODBC Driver

ODBC PowerPack API Driver
1

Introduction

This article guides you through connecting to the Dropbox API in ODBC API Driver, enabling seamless integration and management of Dropbox data using the ZappySys ODBC Dropbox connector.

Prerequisites

  • ODBC PowerPack: Download and install the ZappySys ODBC PowerPack from the Customer Download Area or the trial version.
  • Have a Dropbox account: Ensure you have a Dropbox account to access Dropbox data.

Steps

Create/Select an App from the Dropbox Developers Page

  1. Log into your Dropbox account.

  2. Go to Dropbox Developers and click the Create app button to create a new app.

    Dropbox dev page
    Dropbox dev page950×482 20.8 KB

  3. Select the Scoped access option when prompted.

  4. Choose Full Dropbox to access all files and folders or App folder to access specific folders’ files and folders.

  5. Provide a name for your App and click Create App.

  6. Under the Permission type section, click Scoped App to select application scopes.

  7. Choose all Individual Scopes and Team Scopes if managing team data is necessary, then click Submit.

  8. Navigate to the Settings tab, and copy the App key and App secret to Notepad.

Create a New Driver

  1. Open the ODBC Data Source by typing “ODBC” in the search box and launching the ODBC Data Source.
    Open ODBC Data Source

  2. To gain access for yourself or other users, go to the User DSN or System DSN. Go to the System tab for SQL Server Integration and add a new System DSN. Click the “Add” button.
    ZappySys ODBC Driver - Open UI

  3. From the driver list, select ZappySys API Driver, then select Dropbox in the connector list and press Continue.

    Select Dropbox Connector
    Select Dropbox Connector625×506 50.3 KB

Dropbox Connector Configuration

  1. Fill in the connector fields, including Client ID, Client Secret, and Scopes (separated by spaces) like this:
    account_info.read account_info.write files.metadata.write files.metadata.read files. Content. write files.content.read.

  2. Generate the token and test the connection.

    Dropbox connector
    Dropbox connector810×720 55.9 KB

  3. Go to the Preview Tab, select any table, and preview the result. Press OK to save the configuration.

    Preview Data
    Preview Data814×656 42.3 KB

Considerations

Save the credentials so you do not have to search for them in your account every time.

Video Tutorial

Conclusion

Following these steps, you can seamlessly connect to Dropbox within ODBC API Driver, leveraging the ZappySys tool for efficient data retrieval and integration. For assistance or inquiries, contact our support team via chat on our website.

References

You can check our Dropbox connector article here.