https://community.qlik.com/t5/Talend-Studio/Google-BigQuery-Connection-via-JDBC/m-p/2375145#M137620 <P>Hi All,</P><P></P><P></P><P>I am trying to establish Connection with Google BigQuery via SIMBA JDBC Adapter in Talend Open Studio.</P><P></P><P></P><P>I am using following format for JDBC URL.</P><P></P><P></P><P>jdbc:bigquery://{host}:{port};ProjectId={database};OAuthType=0;OAuthServiceAcctEmail={user};OAuthPvtKeyPath={server};\</P><P></P><P></P><P>Keeping user name and password empty.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L0tkcAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136064i7C3599A38A0EB605/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L0tkcAAB.png" alt="0695b00000L0tkcAAB.png" /></span></P><P></P><P></P><P>I am getting following error while trying to setup connection.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L0tiDAAR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134344iF2CE8BDAECD5981C/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L0tiDAAR.png" alt="0695b00000L0tiDAAR.png" /></span></P><P></P><P></P> Fri, 15 Nov 2024 23:30:18 GMT kotvir 2024-11-15T23:30:18Z https://community.qlik.com/t5/Talend-Studio/Google-BigQuery-Connection-via-JDBC/m-p/2375145#M137620 <P>Hi All,</P><P></P><P></P><P>I am trying to establish Connection with Google BigQuery via SIMBA JDBC Adapter in Talend Open Studio.</P><P></P><P></P><P>I am using following format for JDBC URL.</P><P></P><P></P><P>jdbc:bigquery://{host}:{port};ProjectId={database};OAuthType=0;OAuthServiceAcctEmail={user};OAuthPvtKeyPath={server};\</P><P></P><P></P><P>Keeping user name and password empty.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L0tkcAAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136064i7C3599A38A0EB605/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L0tkcAAB.png" alt="0695b00000L0tkcAAB.png" /></span></P><P></P><P></P><P>I am getting following error while trying to setup connection.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000L0tiDAAR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134344iF2CE8BDAECD5981C/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000L0tiDAAR.png" alt="0695b00000L0tiDAAR.png" /></span></P><P></P><P></P> Fri, 15 Nov 2024 23:30:18 GMT https://community.qlik.com/t5/Talend-Studio/Google-BigQuery-Connection-via-JDBC/m-p/2375145#M137620 kotvir 2024-11-15T23:30:18Z https://community.qlik.com/t5/Talend-Studio/Google-BigQuery-Connection-via-JDBC/m-p/2375146#M137621 <P>Hello,</P><P>From the trouble screenshot, there are missing jar issue.</P><P>Did you download all required simba drivers and added the JARS into Talend?</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000N1x7eAAB.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157413i7B779DDCDF77B035/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000N1x7eAAB.jpg" alt="0695b00000N1x7eAAB.jpg" /></span>Best regards</P><P>Sabrina</P> Mon, 17 Jan 2022 09:36:27 GMT https://community.qlik.com/t5/Talend-Studio/Google-BigQuery-Connection-via-JDBC/m-p/2375146#M137621 Anonymous 2022-01-17T09:36:27Z