nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Connecting to Google Spreadsheet

jlux33

Is there a data connector for Google Spreadsheets? I desperately need to read data from a Google sheet into a report.

Find more posts tagged with

Comments

kclark

I haven't done any work with Google Spreadsheets but looking at their site it looks like you can connect to them with Java. If you can pull in the data with their API's you can create a scripted data source. Or pull the data into a POJO and use the POJO data source in 4.3

jlux33

I have tried...unfortunately, building ODAs is not my skill. I seem to always have Auth issues. It will work on my Designer, but not on the Tomcat Engine. I really need a solid data connector for Google Spreadsheets. I will keep hacking at it.

BRM

Talend has a Google Spreadsheets connector. You could use that to extract the data from the GS to a local datasouce that you could then access with a BIRT connector.

steffen@rugtved.dk

Have you looked at this project: <a data-ipb='nomediaparse' href='http://anthonysdevshare.blogspot.dk/2008/12/extending-birt-google-spreadsheet-oda.html'>http://anthonysdevshare.blogspot.dk/2008/12/extending-birt-google-spreadsheet-oda.html</a>It works for me on Juno Service Release 1, but for some reason not on the latest BIRT Report Designer. Best RegardsSteffen Rugtved