Questions tagged [simba]

Simba is an open source program which can be used to automate tasks.

Simba is an open source program which can be used to automate tasks. The capabilities of Simba include:

  • Finding and reading colours on the screen.
  • Clicking or moving the mouse to a specific position on the screen.
  • Reading text on the screen and turning it into actual text. (Optical Character Recognition)
  • Capturing and analysing images on the screen.
  • Reading and writing files.
78 questions
1
vote
1 answer

Cassandra Simba driver doesn't respect fetch size

I'm using CassandraJDBC42.jar and I added setFetchSize=200 and I tried to pull 100k data it took a while so I tried to setFetchSize=5000 and it took the same time
aya ahmed
  • 11
  • 1
1
vote
0 answers

Alteryx connection to Oracle database

I am trying to connect to oracle database through Alteryx. I keep getting the same error message as below: connection error im003 specified driver could not be found due to system error 126: the specified module could not be found. (simba oracle…
Leena
  • 247
  • 1
  • 7
1
vote
1 answer

How to fix [Simba][DriverOAuthSupport] Authentication failed: invalid_grant error?

I'm using ODBC connector to connect to data in Google BigQuery which was working fine but is now giving this error. Would be grateful if you could help advice how to fix this error.
Mishal
  • 450
  • 9
  • 27
1
vote
1 answer

BigQuery - Simba JDBC Connection Error Unrecognized character escape 'S'

I am using Simba Big Query JDBC connector in a simple java application. I am using Google Service Account for user authentication. For OAuthPvtKeyPath, I am using the json key file. My connection url looks like this…
gsurjit
  • 11
  • 2
1
vote
0 answers

Connect to the Azure Databricks via odbc using python and Azure AD

Could you please give me some instructions or resources (as I am not able to find anything that could potentially point me to the right direction) with information of how to connect to the Azure Databricks using odbc (python simba driver) and Azure…
kamroj
  • 23
  • 4
1
vote
0 answers

Spotfire - Biquery - Simba JDBC

I could not find an anwser to the following question. I have been testing Spotfire with BigQuery connector in the last week. I am using Simba JDBC driver. it works well ~1min per Go of Data import to memory. This is fast thanks to the BigQuery…
tarik
  • 21
  • 2
1
vote
1 answer

Simba ODBC connection to delta table & read data from delta format tables using .Net C#

I am trying to read data from delta format tables using c# via simba odbc driver. delta format table sample : https://docs.delta.io/latest/quick-start.html#-create-a-table&language-python Have downloaded and configured simba odbc as instructed…
Rak
  • 196
  • 2
  • 9
1
vote
1 answer

Increase Scope in Personal account to access Bigquery tables sourced from Google Sheets

I am using Data Grip with Simba JDBC connection and when I try accessing a Bigquery table sourced from Google Sheets, it gives me an error provided below. This works fine if I run from the Big query UI. Also, if I create a new table with this table…
1
vote
0 answers

SSL Error in Big Query using Simba ODBC Driver C#

I am using Simba ODBC driver (32-bit) to query data from Google Big Query using C#. I keep getting the below error one or two times per week. Please help as I am not sure how to resolve this error. ERROR [HY000] [Simba][DriverSupport] (1160)…
1
vote
0 answers

Error executing a query involving MD5() function through Simba's JDBC driver

When I do a query through Simba's JDBC Driver 4.2 1.2.1.1001 version using MD5 function e.g: SELECT md5('Hello World') AS hash_value from testdataset.table_sample I get the following error trace: java.lang.NoClassDefFoundError:…
juanjovn
  • 492
  • 4
  • 8
1
vote
0 answers

How to insert Binary base 64 data into MongoDB through Simba JDBC driver?

I want to write an insert SQL query to insert Binary base64 data into MongoDB through Simba JDBC driver. I am able to do that through MongoDB Compass tool, but through SQL insert query, I'm not able to proceed. In my Java code I have tried to write…
Nishant
  • 53
  • 5
1
vote
2 answers

Connecting Couchbase with Apache Drill

I am trying to connect using jdbc connection (the driver here: https://github.com/jdbc-json/jdbc-cb) apache drill with couchbase. My storage configuration is: { "type": "jdbc", "driver": "com.couchbase.jdbc", "url":…
1
vote
1 answer

Unable to connect to Impala through Java app using Impala JDBC Driver

I am trying to connect to impala and do a simple select query using JdbcTemplate(). I keep getting the following error: java.sql.SQLException: [Simba][ImpalaJDBCDriver](500164) Error initialized or created transport for authentication: null. at…
3Libras
  • 23
  • 1
  • 5
1
vote
1 answer

License key for BigQuery JDBC Driver?

BigQuery's website features a new JDBC driver from Simba downloadable from GCS at https://cloud.google.com/bigquery/partners/simba-drivers/. The documentation states that a license (.lic) file needs to be installed with the JARs, but there is no…
Stuart Ozer
  • 1,354
  • 7
  • 7
1
vote
0 answers

Interpret UUID Data from DSE to Tableau

Consider there is a table in DSE 4.8.3 Cassandra: CREATE TABLE retail.test_orders2 ( order_id uuid PRIMARY KEY, order_name text ) select * from test_orders2; order_id |…