Questions tagged [cdata-drivers]

cdata-drivers provide standard (ODBC/JDBC) based connection to various SaaS APIs like Salesforce, Google Apps and many more.

34 questions
2
votes
2 answers

How to authenticate Salesforce through CData ODBC driver via OAuth?

I have installed CData ODBC driver for Salesforce and able to connect Salesforce through username, password and security token. I wanted to access through OAuth as well. I have followed all the steps mentioned in the link below. How can we go…
Prajna
  • 578
  • 4
  • 8
  • 23
2
votes
0 answers

Anyone Know "How to connect Power Bi Cloud version with Netsuite via ODBC ?"

I am new to Power Bi cloud version, I need to connect power Bi with Netsuite(version 2018.2).As i am able to connect Power Bi Deskop with Netsuite using ODBC connection.But for Power bi Cloud version i am not getting how to do the ODBC…
Jai
  • 21
  • 2
1
vote
1 answer

SSIS Adding Text Qualifier to Imported Data

I am trying a CData Driver to import reports from Quickbooks Desktop and export them out as a flat file. The fields are GL_ID, Debit, Credit However, when SSIS loads this file, the fields are not currently using text Qualifiers(GL_ID= Hello, World…
user3590113
  • 517
  • 7
  • 13
1
vote
1 answer

CData JDBC Couchbase Java app connection problem

I can't manage to get this right. I'm not sure of what is wrong. Apparently the connection is ok but can't get the result back of the query. package probandoCouch; import cdata.jdbc.couchbase.CouchbaseDriver; import java.sql.Statement; import…
Calipox20
  • 11
  • 1
1
vote
1 answer

SSIS Chunk Timeout Errors exporting data using CData Snowflake Source

Anyone run into this error? How do I resolve, not getting much guidance from cdata or snowflake. Error: 0x0 at ADI_PRODUCT, CData Snowflake Source: Get data error: Retrieved Chunk#0 Timeout. Error: 0xC0047062 at ADI_PRODUCT, CData Snowflake Source…
1
vote
0 answers

Facebook Cdata ODBC connector not getting likes table data

I have installed CData ODBC driver and Setup DSN Connection for my facebook page using that driver. The problem is that i am not getting facebook Page "likes" table data as mentioned in their document…
adnan
  • 504
  • 1
  • 4
  • 21
1
vote
1 answer

Is it possible for parallel processing in Oauth authentication

I am trying to use multi thread for connecting CData drivers. Whether is it possible for parallel processing of data in CData. OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = "xxxx"; Task task1 = Task.Factory.StartNew(() =>…
1
vote
1 answer

What is a RSBOperation, in the context of CData's JDBC library for access to QuickBooks.=

I am using the JDBC driver from CData(cdata.com) to access a QuickBooks instance. The code below is right off the CData website(with the exception of qbConnString). The getConnection call works fine, but an exception is thrown when the query is…
john ware
  • 153
  • 1
  • 8
1
vote
1 answer

Can't establish ODBC connection to SharePoint

I'm trying to connect to SharePoint using the free "CData" ODBC Driver for Sharepoint. Wehn trying to configure the DSN, I enter the SharePoint site I am using (sharepoint.xx.xxx.com) I then enter the username (user@domain.com) and password that I…
Bharat M
  • 109
  • 7
1
vote
1 answer

connect Hbase to Tableau using cdata

I am trying to connect hbase using ODBC Driver but not getting tables in in my tableau screen when I am selecting cData. I am using my server ip and hbase port 16000.If I am entering table name getting error (An error occurred while communicating…
ankit arora
  • 89
  • 15
1
vote
3 answers

Connect Tableau to plain Hbase

Is there any way to connect Tableau Desktop to plain Apache Hbase or plain Hive ? I could only find Tableau drivers for Hortonworks/ MapR/ Cloudhera etc.
ankit arora
  • 89
  • 15
0
votes
0 answers

SSAS cube process from Google big query using Cdata ADO.net driver

I have created a multidimensional cube from a data source located on Google BigQuery cloud database. To connect the SSAS cube to BigQuery, I have utilized the CData ADO.net provider for BigQuery. The cube I created is relatively simple, consisting…
0
votes
1 answer

Using the Filter Type UpdatedAt with Marketo Activity Bulk Extract API

We are trying to use the Marketo Activity Bulk Extract API to get Activities within a certain date range. However, there doesn't seem to be a high watermark (updatedAt, lastModifiedDate etc) filter available for this API. Please advise
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
1 answer

"Error parsing int value [#N/A]" when querying a Google Spreadsheet using CDATA

We are trying to query a Google Spreadsheet that has some fields with #N/A in them. #N/A errors in Google Spreadsheet indicate missing information and signal functions to cease calculation. We just want want these #N/A values to be treated as…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
1 answer

Using SQL code, i need to create a string that automatically creates the dates between to seperate days

I am creating an automatically updating dashboard for repeating purposes and I need to automatically draw invoice values from our system between certain dates i.e. on Tuesday, the reporting needs to show Mondays invoices. Is it possible to create a…
1
2 3