Blue Prism - ODBC - BigQuery

PABLOPEREZ-ENCI — Wed, 21 Apr 2021 16:36:12 GMT

We have created an ODBC connection to database BigQuery.

We need to connect to the database (BigQuery) and query from Blue Prism (6.3), What would be the best solution?

Regards

Re: Blue Prism - ODBC - BigQuery

PabloSarabia — Wed, 21 Apr 2021 16:53:01 GMT

Hi Pablo,

If you finally create an ODBC, you can use the "OdbcConnection" class to connect with the data base.

Need to add this reference to your object: "System.Data.Odbc"

And the code looks like this:

string queryString = "QUERY HERE";
OdbcConnection conn = new OdbcConnection(connectionString)
conn.Open();
OdbcCommand cmd = new OdbcCommand(queryString);
cmd.Connection = connection;
cmd.ExecuteNonQuery();

But, BigQuery have an especific library to use it with .Net. Here you can read all about this: https://cloud.google.com/bigquery/docs/quickstarts/quickstart-client-libraries

I think the second option is better.

Hope this help you.

Bye 🙂

topic Blue Prism - ODBC - BigQuery in Product Forum

Blue Prism - ODBC - BigQuery

Re: Blue Prism - ODBC - BigQuery