Stack Overflow
Stack Overflow

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
0
votes
1 answer

Data Transfer from Sql Server to Elasticsearch with SSIS and CData

I am trying to data transfer from Sql Server to Elasticsearch with SSIS(Microsoft SQL Server Integration Services) application using CData Elasticsearch Destination tool. What I am successfully for now. Using SSIS I am getting data from Sql…
HKN
  • 13
  • 6
0
votes
0 answers

get tally data by company wise using ado.net

I am having 3 companies in my tally . I am getting the data from tally using cData ADO.Net Provider. Now, I can get only Selected company data from tally. But I want to get all the selected company data for example if 2 companies are showing in the…
Saravanan
  • 1
  • 1
0
votes
1 answer

OAuth with CData JDBC Driver for XML - Files on Google Drive - CallbackURL not Used

I am using the CData JDBC Driver for XML to read XML files to my java application and some of those files are on google drive so OAuth is needed. I am following the Authenticate to XML from a Web Application flow specified on CData website. The…
Selim Alawwa
  • 742
  • 1
  • 8
  • 19
0
votes
1 answer

How to find out the Object Type in a Salesforce Polymorphic relationship using the CData Salesforce Driver

Occasionally Salesforce Object have polymorphic relationships with other Salesforce Objects. In a polymorphic relationship, the referenced object of the relationship can be one of several different types of object. These polymorphic relationships…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
1 answer

Location field not accessible when using the UseBulkAPI connection option in the CData Salesforce ODBC Driver

We are using the CData Drivers to retrieve the Data from the Location Object in Salesforce. When we set the UseBulkAPI connection option to True in CData, the Location field in the Location Object is not accessible. If we set the UseBulkAPI…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
1 answer

Retrieve the formulas from the Salesforce Formula fields

I am looking for a way to get the formulas from Salesforce Formula fields. We are using the CDATA Drivers to connect to Salesforce. But I am not seeing any option to retrieve the Salesforce formulas.
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
0
votes
1 answer

How to authenticate Salesforce through CData ODBC driver via OAuth's accessToken?

I am only able to fetch salesforce data from username and password as below. cnxn = pyodbc.connect("DRIVER={CData ODBC Driver for Salesforce};User=myUser;Password=myPassword;Security Token=myToken;") But If I don't want to give username and…
Deepak N
  • 1,408
  • 3
  • 15
  • 37
0
votes
1 answer

How to access Salesforce data through CData ODBC driver using python with using Salesforce Access Token of the user from OAuth autherization?

I have a web application and I want to integrate Salesforce to that. So when the OAuth2 authorization happens from the user side(he logs in and give access for our application to access his data). After the user gives access I will be getting the…
Developer
  • 123
  • 1
  • 3
  • 14
0
votes
0 answers

Fetch tables size in CData connectors

I just want to fetch the size of tables provided by CData connectors like "Salesforce,MongoDb,etc". So if anyone can help me in this.
harshit saxena
  • 111
  • 5
0
votes
1 answer

How can we get table size in Salesforce using CData driver?

I want to fetch the size of my table in Salesforce using a CData driver.
Nisha Tamta
  • 13
  • 6
0
votes
1 answer

How to connect to a remote file using CData Excel JDBC driver?

Using CData to connect to local excel file with jdbc url below: Connection conn = DriverManager.getConnection("jdbc:excel:Excel File=C:\MyExcelWorkbooks\SampleWorkbook.xlsx;"); Can we connect to a remote file using CData, If so what can be the…
user10512791
  • 63
  • 1
  • 13
0
votes
0 answers

CDATA ADO Connection with Crystal Reports not showing data

I have VS2015 solution with Crystal Reports and CData Ado.net connection for the dataset. I have followed the instructions but my crystal report has three tables with two linked tables. The report fires and works with just the primary table but…
Andrew Little
  • 27
  • 1
  • 7
0
votes
1 answer

Dynamically decide columns in SSIS connectors for salesforce

I want migrate data from salesforce to SQL server and I am using SSIS connectors for salesforce. I am creating single SSIS package which fetch data for all objects and insert into SQL server. I tried using following connectors for…
Satishakumar Awati
  • 3,604
  • 1
  • 29
  • 50
0
votes
1 answer

How to create a MongoDb data source with cdata Driver in weblogic12.2.1

I want create MongoDb data source in weblogic12.2.1 and use Connect to MongoDB from a Connection Pool in WebLogic but have a error to create this data source. my config is: Driver Class Name: cdata.jdbc.mongodb.MongoDBDriver URL:…
seyedmohsen Mirhosieni
  • 41
  • 9
0
votes
1 answer

Create a JDBC connection to HBase

I am trying to cretae a JDBC to connection to HBase in our cluster using CDATA (https://www.cdata.com/kb/tech/hbase-jdbc-dbvr.rst) The HBase properties in our cluster is as…
Luckylukee
  • 575
  • 2
  • 9
  • 27
1
2
3