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:
jdbc:googlesheets:user=myuseraccount;password=mypassword;Spreadsheet=SpreadsheetName
The GoogleSpreadsheet Driver is already bundled with the product. Select this driver from the Database Driver drop-down list as shown in the video
Comments
0 comments
Article is closed for comments.