{"id":395,"date":"2023-06-06T20:40:00","date_gmt":"2023-06-06T20:40:00","guid":{"rendered":"https:\/\/quadbase.com\/blog\/?p=395"},"modified":"2023-06-21T20:10:34","modified_gmt":"2023-06-21T20:10:34","slug":"connect-to-bigquery-data-when-creating-reports-with-espressreport-es","status":"publish","type":"post","link":"https:\/\/www.quadbase.com\/blog\/connect-to-bigquery-data-when-creating-reports-with-espressreport-es\/","title":{"rendered":"How to access BigQuery data for creating reports in EspressReport ES"},"content":{"rendered":"
\n
\"\"<\/figure>\n<\/div>\n\n\n

In this article, we will explain how to use the JDBC driver from CData to access BigQuery data from EspressReport ES and visualize it. CData Software offers about 250 types of various JDBC Drivers that can connect to BigQuery, Dynamics 365, JIRA, etc.<\/p>\n\n\n\n

By using these various JDBC drivers and the Data Registry Manager in EspressReport ES, you can access data from all kinds of data sources in the Cloud and SaaS applications for robust reporting and visual analytics.<\/p>\n\n\n\n

Driver Preparation<\/strong><\/h2>\n\n\n\n

First download the installation package based on different systems such as Windows, Linux and Mac from the URL below.<\/p>\n\n\n\n

https:\/\/www.cdata.com\/drivers\/bigquery\/download\/jdbc\/<\/a><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

After downloading the installer, proceed with the setup according to the dialogs.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Once the setup is complete, if you choose the default installation directory, the JDBC Driver will be located in “C:\\Program Files\\CData\\CData JDBC Driver for Google BigQuery 2022\\lib”. You will find 3 files that you need to use to set up the driver for EspressReport ES.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Copy these 3 files from “C:\\Program Files\\CData\\CData JDBC Driver for Google BigQuery 2022\\lib” to “<ERES installation>\\WEB-INF\\lib”.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

NOTE:<\/strong> Ideally, do this while the ERES server is shut down. If the ERES server is running while you\u2019re copying the driver files, please restart the ERES server after copying the driver files.<\/div>\n\n\n\n

Connection Steps<\/strong><\/h2>\n\n\n\n

Activate Google Cloud BigQuery sandbox<\/strong><\/h3>\n\n\n\n
    \n
  1. In the Google Cloud console, go to the BigQuery<\/strong> (Go to BigQuery<\/a>)<\/li>\n<\/ol>\n\n\n\n

    You can also open BigQuery in the Google Cloud console by entering the following URL      in your browser: https:\/\/console.cloud.google.com\/bigquery

    <\/a>The Google Cloud console is the graphical interface that you use to create and manage BigQuery resources and to run SQL queries.<\/p>\n\n\n\n

      \n
    1. If you’re not logged into a Google account in your web browser already, you will have to authenticate using an existing Google Account or create a new account.<\/li>\n\n\n\n
    2. On the welcome page, do the following:\n