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
0
votes
4 answers

Can we query google big query public datasets using Simba JDBC driver?

I want to test connectivity and queries using Google Big query for google query pubic projects/datasets like "bigquery-public-data" or any other public datasets using Simba JDBC driver. I tried different authentication mentioned in Simba driver…
0
votes
2 answers

List all databases of mongoDB through Simba JDBC driver

I am new to MongoDB. How to list all databases of mongodb through Simba JDBC driver. have tried alot but I am only able to get the name of database through which I have build the connection URL. Even, I am not sure that, is this possible or not to…
Nishant
  • 53
  • 5
0
votes
0 answers

How to use _PARTITIONTIME with Simba's BigQuery JDBC Driver?

Is there any way to list the _PARTITIONTIME field while using the JDBC provided by Simba/Google? https://cloud.google.com/bigquery/partners/simba-drivers/ I could not find any information regarding this in their documentation. Found these…
0
votes
1 answer

Default and maximum length of VARCHAR

I am very new to Apache Phoenix. I have created table using query in SQuirrel SQL client. Here I shared the sample query below. CREATE TABLE IF NOT EXISTS Sample(Action VARCHAR NOT NULL, Title VARCHAR, Email VARCHAR, Type VARCHAR CONSTRAINT PKforum…
Kavitha M
  • 263
  • 1
  • 7
  • 23
0
votes
1 answer

How long is the user token for BigQuery using SIMBA ODBC driver valid?

We are connecting to Google BigQuery using SIMBA ODBC driver, and using user authentication while connecting. There is a key token which is generated for the connection. For how long is this key token valid? When would it expire?
0
votes
0 answers

How to obtain SIMBA SPARK ODBC Driver Version 1.0.8?

Currently, I’m using Tableau 9.3, to work with Hadoop environment I need SIMBA SPARK ODBC Driver Version 1.0.8. If anyone has it please share a link to download it.
0
votes
2 answers

SQL Query Error with CASE Statement?

I'm attempting to run this query using Simba's ODBC SFDC driver but the log shows me an error near the case statement. I'm not totally convinced its an error with the CASE statement but I don't see where my error is. Someone please help!!!! SELECT …
sqlbg
  • 73
  • 1
  • 11
0
votes
0 answers

Simba SFDC ODBC Driver Error Message (-7711)

I'm using Simba's Salesforce ODBC Driver and keep getting error message (-7711). Below is the what I believe to be part of the log where the error resides but I'm unable to determine what's causing the error message and how to resolve it. Can anyone…
sqlbg
  • 73
  • 1
  • 11
0
votes
0 answers

Error when trying to do multiple joins in tableau

I am trying to build a report in tableau desktop 9.3.2 with mongodb (live connection). I using the simba odbc driver for mongodb. I trying to join tables but I keep getting errors if I perform more than one joins and also I cannot do anything…
kg1889
  • 3
  • 2
0
votes
1 answer

Connect to mongodb with simba odbc driver with kerberos authentication

I am using the simba odbc driver with sql connector on windows 7 machine. I am trying to connect to a remote server that has the data using Kerberos authentication using a keytab file. I am having a difficult time figuring out how to do this. I saw…
kg1889
  • 3
  • 2
0
votes
0 answers

Connection to HBase with Simba ODBC driver

I always get this error for connecting to HBase with Simba ODBC driver: Failure: [Simba][HBase] (20) Error with HTTP API: Couldn't connect to server. Can anyone help?
Wahyu
  • 1
0
votes
0 answers

Simba Cassandra Tableau SparkSQL NullPointerException

I am trying to analyze data stored in DSE 4.8.3 Cassandra using Tableau through SparkSQL. Following is the description of column family I Created in Cassandra: CREATE TABLE demokeyspace.temp ( name text PRIMARY KEY, id int ) The above table…
New Coder
  • 499
  • 4
  • 22
0
votes
0 answers

How to get fetchSize value set from stmt.fetchSize(500) in DSI in simba jdbc sdk

I am using SIMBA SDK 9.5 trail version for creating a custom JDBC4.1 driver to access my data store hive. For testing simba jdbc driver, I have a java class. Below is my sample…
Reena Upadhyay
  • 1,977
  • 20
  • 35
0
votes
1 answer

Query Couchbase Views from Excel using Simba ODBC Driver

I am trying to query Couchbase data from Microsoft Office Excel using Simba ODBC Driver. Querying Table using below statement works: However, when I tried to query views it doesn't work, kept saying "Cannot create table ..." Here's one of the many…
friend
  • 1,909
  • 2
  • 21
  • 28
0
votes
2 answers

Simba error loading metadata

I am using Simba ODBC driver to connect to a MongoDB database from Tableau. I use default config and get an Error: There was an error loading metadata: That's it. No details. I manage to connect to other databases from the same MongoDB server, but…
Dragos
  • 2,911
  • 12
  • 39
  • 55