I am trying to configure iReport from Jaspersoft with BigQuery and I am following every step posted on the Internet but they don't work.
The specific steps to configure this are following those from here
The main step is to create a Project in BigQuery which gives you 3 main things:
- the Project ID
- the Client ID
- the Client Secret
With these parameters you can create the
JDBC URL explained here which is required to connect iReport with BigQuery.
BUT, when you get to the part when you only have to put the Credentials (username, and password) on the "New Database JDBC Connection" creation of iReport, I can't use my
Client Secret, iReport requests the
<path to key file>, which I think is a
*.p12 file, because iReport gives this error:
QL problems: java.io.IOException: toDerInputStream rejects tag type ##
Please help either on creating this
*.p12 file and see what happens or maybe giving me the exact steps to make this configuration work, if any of you have configured this correctly.