Accessing Google document spreadsheet using google-spreadsheet translator in Teiid Designer.
Issue
I am trying to access Google document spreadsheet using google-spreadsheet translator so need info on the following to create VDB using google spreadsheet data source?
-
Is there importer or do we need to create table structure manually with the column name matching to spreadsheet column name and table name matching to worksheet name?
-
Need Data Source configuration information using google account user name and password ?
Please also provide If you have any example VDB created for Google document spreadsheet data source or available online.
Environment
- Red Hat JBoss Data Virtualization 6.0.0
- Teiid Designer 8.3.2 or greater
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.