Blue Prism - ODBC - BigQuery

[PABLOPEREZ-ENCI]

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

[PabloSarabia]

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 🙂