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

Issues after connecting hbase from Tableau with Simba driver

After connceting to hbase with Simba driver,most of the measures are visible in String format in Tableau though they are loaded as integer from hbase end,what might be the reason?Though I am converting measures from strings to decimal format in…
Sahasra
  • 11
  • 1
1
vote
1 answer

Simba Spark ODBC Driver is not working ms excel

I am using Spark(1.5.0) for utilizing Spark-SQL feature using Spark ThriftServer application and also using Simba Spark ODBC Driver for getting connection. Using Tableau, I am able to connect and able to do Spark-SQL operations. But when, I tried to…
Kaushal
  • 3,237
  • 3
  • 29
  • 48
0
votes
1 answer

How to include SIMBA ODBC drivers as part of docker file for local testing using docker desktop?

I have implemented a .Net webapi application which pulls the data from databricks Applications . I have installed SIMBA ODBC drivers in my local and was able to connect to databricks cluster from my local .net application. Now I want to run &…
191180rk
  • 735
  • 2
  • 12
  • 37
0
votes
1 answer

Java GCP bigquery simba jdbc connection timeout

I am trying to connect GCP bigQuery from local using simba jdbc but getting error. Previously I had got Service account role permission issue , those were resolved by adding necessary roles for service account java.sql.SQLException:…
vinayak_narune
  • 737
  • 1
  • 10
  • 26
0
votes
1 answer

SSRS + BigQuery: How to pass SSRS's Parameter into BigQuery query syntax?

Background: I have an existing SSRS report (Report Builder) which is connected to SQL server as a data source. The report contains main query, and parameters. In below screenshot, they are 'MainQuery' dataset, and 'Year' and 'Month' parameters…
0
votes
0 answers

Teradata to BigQuery using SSIS

I am trying to move data from Teradata to BigQuery using the Simba BigQuery ODBC driver in SSIS but I am getting errors either saying "The number of Columns is Incorrect" or "Dataset not Found" when I am trying to define the Big Query table name in…
Surya
  • 1
0
votes
0 answers

JDBC driver jar com.simba.spark.jdbc4.Driver

I'm trying to create a JDBC connection to my local spark environment. I'm looking to "com.simba.spark.jdbc4.Driver" JAR file - Version 4. I'm using IBM Cognos Analytics do create the JDBC connection which use the version 4 of JDBC. Someone has the…
0
votes
1 answer

How to add a file path in -SetPropertyValue while adding a DSN through Add-OdbcDsn (Powershell)

I have added DSN for ODBC driver by using below pwoershell script Add-OdbcDsn -Name "My_Connew" -DriverName "Simba ODBC Driver for Google BigQuery" -DsnType "System" -Platform "64-bit" -SetPropertyValue…
Avi
  • 3
  • 2
0
votes
1 answer

Where is simba package in R 4.1.3

I am using R 4.1.3 and I am not able to find the package simba anymore. library(simba) `Error: package or namespace load failed for ‘simba’: package ‘simba’ was installed before R 4.0.0: please re-install it It is not present anymore in install…
jammah
  • 25
  • 5
0
votes
1 answer

Pentaho - Big Query [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: BIGQUERY_API_ERR

In pentaho I get an error when I read a BigQuery table with a "Table Entry", I have these considerations: This table was created from a Google Drive sheet with the service account I can read this table with "Google Sheet Plugins" [1]:…
0
votes
1 answer

Pass ssrs parameter to bigquery SP

I can call from SSRS BiqQuery SP when I put parameter manually (, but when I try to give report parameter to SP I got this error message. "Error [42000] [Simba]Bigquery Invalid query: Syntax error: Expected end of input but got identifier…
0
votes
2 answers

How to set non-US location in BigQuery ODBC? (Magnitude Simba on Linux)

Maybe anybody knows... I need to connect BigQuery via ODBC driver by Simba (Linux). I've installed it. My datasets located in EU, but every single request via ODBC driver I get "Dataset is not found. Not found: Dataset **** was not found in location…
0
votes
0 answers

Insert records into Google Bigquery from SQL server using Simba ODBC driver

I am using Simba ODBC driver to connect SQL server to Google Bigquery. While I am able to perform SELECT from Bigquery at SQL side, I am NOT able to INSERT into Bigquery from SQL. This query works: EXEC('insert into…
Delin Mathew
  • 249
  • 3
  • 6
  • 15
0
votes
1 answer

Databricks Spark connection issue over Simba JDBC

I am trying to connect Spark Databricks from PERL code over Simba JDBC (Databricks recommended way) .For ref this is the JDBC driver:…
pauldx
  • 833
  • 1
  • 12
  • 22
0
votes
0 answers

DetailsODBC: ERROR[HY000] [Simba][BigQuery] (115) Operation Timeout. PollJob

Ive got a problem when trying to create a new visual for a query (source is Google BigQuery). I'm using a similar query, that is already working (but with an extra filter), making the new query take a little longer. It runs for about 10 minutes, and…
Maho Lau
  • 47
  • 7