Google Spreadsheets to Database

In this ETL example we will create a Data Interface to extract Benefits data from a Google Spreadsheet and load it into a Database. Refer to the attached data integration video on the steps involved in setting up a data interface between a source and target application.

The JDBC URL in the DB Info activity to configure the Google Spreadsheet connection uses the following format:


The GoogleSpreadsheet Driver is already bundled with the product. Select this driver from the Database Driver drop-down list as shown in the video

Have more questions? Submit a request


Article is closed for comments.