How to connect Google Drive in ODBC Driver

ODBC PowerPack API Driver
1

Introduction

This article guides you through connecting to the Google Drive API in the ODBC API Driver. This enables seamless integration and management of Google Drive data using the ZappySys ODBC Google Drive Connector.

Prerequisites

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

Steps

Create/Select a Project in Google API Console:

  1. Navigate to the Google API Console.

  2. Click on the Project Dropdown at the top bar and either select an existing project or create a new one by clicking CREATE PROJECT.

    Create Project
    Create Project744×230 20.9 KB

  3. Once the project is set, click ENABLE APIS AND SERVICES.

  4. Enable both Sheets API and Drive API by searching for them and clicking ENABLE.
    Enable Google Driver API

  5. Return to the main screen and click on the OAuth Consent Screen tab. Provide the necessary details and save.

  6. Move to the Credentials tab.

  7. Click CREATE CREDENTIALS in the top bar, choose OAuth Client ID, select Desktop App as the Application Type, and click Create to obtain your Client ID and Secret.

    Create Credentials
    Create Credentials871×334 38.8 KB

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 Google Drive in the connector list and press Continue.

    Select Google Drive Connector
    Select Google Drive Connector625×506 50.3 KB

Google Drive Connector Configuration

  1. Fill in the connector fields, including Client ID, Client Secret, and Scopes.

  2. Generate the token and test the connection.

    Google Drive Connector
    Google Drive Connector806×706 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 Data804×704 51.4 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 Google Drive within the 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 Google Drive connector article here.