Accessing Google document spreadsheet using google-spreadsheet translator in Teiid Designer.

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content