CData Drivers & Connectors

Share product questions and get support for CData Drivers & Connectors

  • 103 Topics
  • 190 Replies

103 Topics

R
rocketmaniacApprentice
asked in CData Drivers & Connectors

UpdateCommand.Parameters have wrong value in ADO.NET Provider for Presto

Following the example code for Update, we have this against one of our Hive transactional datastores: PrestoDataAdapter dataAdapter = new PrestoDataAdapter("SELECT _id, name FROM hive.transactional_schema.[TableName]", connection); dataAdapter.UpdateCommand = new PrestoCommand( "UPDATE hive.transactional_schema.[TableName] SET name = @name " + "WHERE _id = @_id", connection); dataAdapter.UpdateCommand.Parameters.Add(new PrestoParameter("@name", "name", DbType.String)); dataAdapter.UpdateCommand.Parameters.Add(new PrestoParameter("@_id", "_id", DbType.String)); dataAdapter.UpdateCommand.Parameters[1].SourceVersion = DataRowVersion.Original; DataTable table = new DataTable(); dataAdapter.Fill(table); DataRow firstrow = table.Rows[0]; firstrow["name"] = firstrow["name"] + "-Updated"; dataAdapter.Update(table);firstrow shows the updated name property, but the query that gets sent to Trino is:UPDATE "hive"."transactional_schema".[TableName] SET "name" = 'name' WHERE "_id" = '_id'so I gu

4
L
4 months ago
Q
quangdutran809Collaborator
asked in CData Drivers & Connectors

AirTable JDBC driver could not detect integer, long (biginteger)

I am using AirTable JDBC driver and getting metadata for tables, but notice that all numeric column in AirTable will be detected as FLOATFor example, these two numbers are integer and long but if I get column type from metadata, all of them are FLOAT with size 8: DatabaseMetaData databaseMetaData = conn.getMetaData();  Is this intentional?

5
Ethem Q
4 months ago
O
OP_TesterApprentice
asked in CData Drivers & Connectors

Python connector for google drive errors out when selecting from one of the system tables

It is failing with an error that is not very descriptive when a query like SELECT * FROM sys_connection_hierarchy is executed in PythonThe same query works fine in JDBC. Can you please advise?

2
Ethem Q
4 months ago
Q
quangdutran809Collaborator
asked in CData Drivers & Connectors

Is "CREATE TABLE" supported with Cdata JDBC Drivers for NoSQL database?

I have looked at the document: https://cdn.cdata.com/help/EEJ/jdbc/pg_overview.htm for Elasticsearch but create table statements could not be found here.So it means Cdata does not support SQL-like create table statement? Is there any way I could create index (Elasticsearch) or collections (MongoDB) with JDBC driver?

2
Q
4 months ago
V
vburd
asked in CData Drivers & Connectors

Cannot update Azure Table with Excel Add-In (trial version)

Hi, I’m trying to update records in an Azure Table with the trial version of the CData Excel Add-In for Azure Table Storage (v23.0.8716). I’ve tried using both an Access Key and a Shared Access Token.I can load the data in Excel without issue but cannot update. I keep getting the following error message:“The url must be a valid http or https url”Has anyone else seen this? Is this a limitation of the trial version?Thanks 

2
V
4 months ago
R
rocketmaniacApprentice
asked in CData Drivers & Connectors

'Unknown datatype: JSON.' in ADO.NET Provider for Presto

I’m getting the following exception when trying to run the following code.  Does the driver support the Trino JSON type?  I don’t see json referenced in GetResultTypeData method source.string sql = "SELECT _id, CAST(extra_columns AS JSON) as extra_columns FROM hive.default.measures";PrestoCommand cmd = new PrestoCommand(sql, connection);PrestoDataReader rdr = cmd.ExecuteReader();  Message: Test method Juniper.Test.Trino.TrinoClientTests.PrestoAdoRead threw exception: System.Data.CData.Presto.PrestoException: [500] Could not execute the specified command: Unknown datatype: JSON. ---> oro230j.TC: Unknown datatype: JSON. Stack Trace: ZN.GetResultDataType(FormulaEvaluationContext )RqC.K(SqlFormulaColumn )RqC.mI(SqlTable , SqlColumn )Rod.C(SqlCollection`1 )Rod.Nd(LLB`2 )Roh.Nd(LLB`2 )KJ.U(SQLQuery , Int32 , RRq )KJ.d(IDataStatement , SQLQuery , QueryParameterCollection , Int32 , String , LeW )RUJ.ExecuteQuery(IDataStatement , QueryParameterCollection , Int32 )RUG.ExecuteQuery(IDataStat

1
Ethem Q
5 months ago
R
rocketmaniacApprentice
asked in CData Drivers & Connectors

How to add/enable header X-Trino-User for ADO.NET Provider for Presto

I’m getting the following exception when trying to run the following code.Is there a way to enable or set the HTTP Header X-Trino-User?PrestoConnection connection = new PrestoConnection($"Server={_configuration["TrinoServerIP"]};Port={_configuration["TrinoServerPort"]};");connection.Open();string sql = "SELECT * FROM hive.default.customer";PrestoCommand cmd = new PrestoCommand(sql, connection);PrestoDataReader rdr = cmd.ExecuteReader();while (rdr.Read()){ Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["Id"], rdr["Name"]));} PrestoAdo  Source: TrinoClientTests.cs line 91  Duration: 1.4 sec Message: Test method Juniper.Test.Trino.TrinoClientTests.PrestoAdo threw exception: System.Data.CData.Presto.PrestoException: [500] Could not execute the specified command: HTTP protocol error. 401 Basic authentication or X-Trino-User must be sent. ---> oro230j.TC: HTTP protocol error. 401 Basic authentication or X-Trino-User must be sent. Stack Trace: LdJ.j(Lax[] , Int32 , Int3

2
R
5 months ago
M
MalcolmApprentice
asked in CData Drivers & Connectors

How to connect one Power BI Premium tabular model to another as a datasource?

Hi all,We are migrating from on-prem tabular models to PowerBI Premium models. Most datasources work flawlessly (including the CDATA Snowflake connector). However, we have been unable to use another tabular model as a data source when using PowerBI Premium models…We have the same problem when trying to connect to our Power BI Premium models from our data catalog (Ataccama). OLD On-prem Visual Studio source:Friendly connection name: [model name]Server or File Name: [server] \ [Folder]Database name: [Database name]OLD Ataccama /CDATA JDBC connector:jdbc:cdata:ssas:User=[user];catalog="[catalog]";URL=http://[server]/OLAP/msmdpump.dllNew Connections that work:Excel Connection (Power BI Premium Data Source):Provider=MSOLAP.8;Integrated Security=[];Persist Security Info=[];Initial Catalog=sobe_wowvirtualserver-[GUID];Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://ana

2
M
5 months ago
A
adonApprentice
asked in CData Drivers & Connectors

CRMA to Excel Compatible?

The inquiry is as outlined in the title: I am looking to establish a setup enabling the modification of dashboards and lenses within CRM Analytics directly from an Excel worksheet, ideally facilitating a live two-way connection. If this solution is exclusive to Tableau, I will continue my search. Any recommendations on alternative solutions or platforms to explore would be greatly appreciated!

1
A
5 months ago
G
Gleison ARApprentice
asked in CData Drivers & Connectors

Error to read a view from a MongoDB SSIS Components

Hey guys, I´ve facing an error with this MongoDB component.When I´m trying to setup my data flow at SSIS, I´m facing an error warning that the view that I´ve setup doesn´t exist look to screen shot below:The problem is not in my connection manager, because I can use the same process with an other collection, for example, any view I set, this error appear, Have anyone else seen this before?

1
Ethem Q
5 months ago
V
VenuEmployee
asked in CData Drivers & Connectors

How to use SQLAlchemy 2.0 library with CData Python connector.

When using the Python connector in conjunction with SQLAlchemy, we introduced a new dialect with the "_2" suffix to accommodate SQLAlchemy 2.0. For instance, the QB Python connector features a dialect named "quickbooks_2."Previously, we utilized automap_base in the following manner:engine = create_engine("quickbooks:///?<connection string>")However, if the customer wishes to employ SQLAlchemy 2.0 and prevent potential errors when using automap_base, the following code should be used:engine = create_engine("quickbooks_2:///?<connection string>")

1
Ankit Singh
5 months ago
Q
quangdutran809Collaborator
asked in CData Drivers & Connectors

CData for MongoDB JDBC error Authentication failed

I’ve downloaded JDBC driver for MongoDB but when using it with the correct username password, it throws the error:Exception in thread "main" java.sql.SQLException: Failed to authenticate database 'testdb', Error code: [18] - "Authentication failed."..  Class.forName("cdata.jdbc.mongodb.MongoDBDriver"); Properties prop = new Properties(); prop.setProperty("Server","127.0.0.1"); prop.setProperty("Port","27017"); prop.setProperty("Database","testdb"); prop.setProperty("User","useradmin"); prop.setProperty("Password","welcome!"); Connection conn = DriverManager.getConnection("jdbc:mongodb:", prop); Statement stat = conn.createStatement(); boolean ret = stat.execute("SELECT name FROM users"); It throws error on the last line. These username password are correct and can be used in mongosh inside mongo server container

5
Ankit Singh
6 months ago
J
jmarkmurphyApprentice
asked in CData Drivers & Connectors

SQL Error [HY000]: ORDER BY is mandated in the OVER clause for the function row_number.

I am using the 2023 xBase driver in dBeaver, and receiving this error:SQL Error [HY000]: ORDER BY is mandated in the OVER clause for the function row_number. The Query is:select distinct       'BNK' swityp,       cast(c.cbank_acct as varchar) oldkey,       row_number () over (order by g.cid) newkey,       '' del,       g.cgroup_cod,       g.acct_no,       g.acct_descr,       g.active,       g.cidfrom checkreg cjoin glacct g on g.cid = c.cbank_acctorder by g.cid As you can see I have an ORDER BY in the OVER clause. BTW, changing it to upper case has no effect. What am I missing? Does xBase only partially support row_number? Is there any documentation on the xBase driver and which syntax it supports?

3
Ethem Q
6 months ago
A
ashish.pancholiApprentice
asked in CData Drivers & Connectors

How is your SAP ERP JDBC driver different from the SAP Java Connector (SAP JCo)?

I am wondering if your SAP ERP JDBC driver will help me with my requirement where my Java application running on an external server needs to be communicated with SAP Server via SAP's interfaces like RFC, BAPI, and IDoc.I am new to SAP and found your SAP ERP JDBC driver and SAP Java Connector (SAP JCo) and tried to find the suitable driver that would solve the purpose.Please correct me if I am wrong. SAP Java Connector (SAP JCo) works at the application layer of the SAP R/3 architecture; however, your SAP ERP JDBC driver works at the database layer. Am I understanding it right?

1
Ankit Singh
6 months ago
S
sayed_rakibApprentice
asked in CData Drivers & Connectors

CData ODBC Driver for NetSuite connects to Netsuite.com or Netsuite2.com

Hi,I'm using the CData ODBC Driver for NetSuite (version: 21.0.7867.0 release) to access a customer's NetSuite data. Within the ODBC driver's connection properties, there are no options available to explicitly specify whether to connect to Netsuite.com or Netsuite2.com. Instead, I can provide the Account Id and Version (default 2021_1) for the connection. What data source the CData ODBC Driver for NetSuite is utilizing—Netsuite.com or Netsuite2.com when connecting to the customer's NetSuite? Where can I get this information, thanks. 

2
S
6 months ago
N
narulas8Apprentice
asked in CData Drivers & Connectors

Facebook Connector URL Whilelisting

Hello Team,Can you are aware for  connectors authentication  in restricted environment would require URL Whitelisting and for  Facebook , I have to “facebook.com” done.Still  doesn't work. Am I missing anything,Any quick response would be appreciated.BTW we are working on Facebook, Instagram, LinkedIn and  YouTube CDATA Conectors. RegardsNS   

1
Ethem Q
6 months ago
Luc
LucCommunity Manager
published in CData Drivers & Connectors

Workday NewsletterNewsletter

Finally! Connect to Workday data in your favorite data tools With the Workday Rising event kicking off in San Francisco this week, we’re highlighting CData connectivity solutions that help you bring Workday data to enterprise users directly within the tools they know and love. Now, you can finally access, visualize, and analyze Workday data wherever you need to. CData gives your Workday data wings!CData provides a hassle-free way to connect to Workday data from anywhere. You might even say we give your data wings 🕶Learn more Working in Tableau? Get Zero-ETL Integration with WorkdayAccessing Workday reports in any third-party tool is notoriously difficult. Along with our partners at Tableau, we’re changing that. The best part? We’re doing it all without moving your data from Workday.Read more Hear from our customersBJ’s Wholesale Club improves employee retention by over 10% with CDataConnecting Workday to Tableau gave BJ’s the insights to understand and act on HR trends, helping to imp

3000
Luc
6 months ago
V
varunsharma13Apprentice
asked in CData Drivers & Connectors

Issue With Cadata Excel Connection On New 2019 SQL Server

Current servers are running with SQL 2016 version and in these servers we have CData.SSIS.Excel  (18.0.6705) with 2018 version. This Cdata version is running fine in current server.In the new server which is running on SQL 2019 version, we cannot install this version, so we installed a updated version(22.0.8509) . Below steps are getting performed for package migration from 2016 to 2019: We are converting the solution configuration from 2016 to 2019 and build the solution and deploy the solution to 2019 server. Error That we are getting in package : which was earlier using CData.SSIS.Excel  (18.0.6705) on sql 2016  and now using updated version(22.0.8509) on 2019 SQL server. When we opened the package on new 2019 server, we could not able see the cdata excel connection manager there. So we have to manually create a connection manager, select connection manager on source and deploying the package. What we are looking for is there a way , all these package can run on 2019 sql server with

1
L
7 months ago
G
GatorApprentice
asked in CData Drivers & Connectors

PIVOT queries in SQL - works in FDConnection but NOT in FDQuery - why?

Here is a simple example of a query that works in FDConnection but not FDQuery.  This was tested on the 30 row Excel table using the CDataExcel driver id.  The first component returns a 30 row result set.  The second component fails on “field 2023-01 not found in subquery ….”select "Budgeted Items", "2023-01", "2023-02", "2023-03", "2023-04", "2023-05", "2023-06", "2023-07", "2023-08", "2023-09", "2023-10", "2023-11", "2023-12"  from(  select "Budgeted Items", "MonthNo", "Amount"   from "BUDGETED") as SourceTablePIVOT(  sum("Amount")  for  "MonthNo" in ("2023-01", "2023-02", "2023-03", "2023-04", "2023-05", "2023-06", "2023-07", "2023-08", "2023-09", "2023-10", "2023-11", "2023-12"))

1
L
7 months ago
R
RajasGujarathiCollaborator
asked in CData Drivers & Connectors

Teradata Connection

We are facing issue in connecting to Teradata. On debugging we found the below error. Can someone help? 2023-08-25T09:34:58.217+0000 0 [4|Q-Id] [INFO|Connec] Executed connect: Error: com.teradata.jdbc.TeraDriver2023-08-25T09:34:58.218+0000 0 com.teradata.jdbc.TeraDriverjava.lang.ClassNotFoundException at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:594) at XcoreXcdata.realdb.gld.loadClass(Unknown Source) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:527) at java.base/java.lang.Class.forName0(Native Method) at java.base/java.lang.Class.forName(Class.java:315) at XcoreXteradataX220X8462.fcf.p(Unknown Source) at XcoreXteradataX220X8462.fcf.o(Unknown Source) at XcoreXteradataX220X8462.fcf.i(Unknown Source) at XcoreXteradataX220X8462.prb.aX(Unknown Source) at XcoreXteradataX220X8462.prb.k(

8
P
7 months ago
L
lwhieldonApprentice
posted in CData Drivers & Connectors

Slowness & Latency Using SageIntacct ODBC Driver

I have deployed CDATA Sage Intacct ODBC Driver on an Azure Virtual Machine that also hosts a SQL Server for which we want to copy data from Sage Intacct to table(s) on SQL Server. I have set up my environment 2 ways described in the bulleted list below and BOTH options experience very high latency and slowness when trying to query tables and views created within the Sage Intacct data model; I experience especially very high latency and slowness when querying view, GLDetail, from the CDATA Sage Intacct ODBC Driver:CDATA SQL Gateway/Linked Server: I set up the ODBC Sage Intacct Driver as a service in SQL Gateway and set up a Linked Service on the SQL Server instance that lives on the same machine the SQL Gateway sits on. I followed the steps in the below articles to set it up and also applied caching which did not seem to aid in the increase in throughput to get the data from Sage Intacct. Set up for SQL Gateway: https://cdn.cdata.com/help/RUF/sqlbroker/pg_sqlbrokerservices.htm Set up f

0
L
7 months ago
N
narulas8Apprentice
asked in CData Drivers & Connectors

Can CDATA process unstructured and semi-structured data

Hello Experts,Can CDATA process  unstructured and semi-structured data. Please give us some pointers.

1
Ankit Singh
7 months ago
Lori
LoriEmployee
posted in CData Drivers & Connectors

Q3 CData Driver Tip of the Quarter

Tip:  Build and Deploy a multidimensional model of Snowflake data If you need to create cubes from Snowflake data for more efficient and comprehensive data analysis and you use SQL Server Analysis Services (SSAS) for building enterprise-grade semantic data models, this tip is for you!In a few achievable steps, use CData’s ADO.NET Provider for Snowflake to:Create a data source for Snowflake. Create a data source view. Create a cube for Snowflake. Process the project – deploy the cube to SSAS.Read this article for the detailed steps. Although this example references Snowflake data, CData has hundreds of other low-code ADO.NET Providers, check out this page.NOTE: For SSAS tabular models, please use the ODBC driver instead.

0
Lori
8 months ago
Lori
LoriEmployee
posted in CData Drivers & Connectors

Q3 CData Driver V23 Release - What's New!

At CData, we are committed to providing top-notch data connectivity solutions that optimize data source APIs by leveraging the native functionality of source systems. We constantly improve and maintain our solutions to comply with emerging technologies. To this end, we regularly release driver updates and introduce new drivers to meet market needs.With the most recent release, we are excited to share some notable enhancements for SAP Fieldglass, Shopify, SugarCRM, and improved user experience when using the connection manager.SAP FieldglassSAP Fieldglass is a cloud-based vendor management system that manages the procurement of services and external workforce management systems.  The CData Driver connectivity to SAP Fieldglass now exposes a broader range of data. For example, CData reveals the download data format, custom fields, and Connector names enabled and configured in SAP Fieldglass. CData views use the default SAP Fieldglass Connector name, providing users with an enhanced way t

0
Lori
8 months ago
P
PratikVEmployee
posted in CData Drivers & Connectors

How to uninstall CData Connectors silently

Use the /S Flag to uninstall CData Connectors in silent mode.Assume, for example, that you have the SharePoint ODBC driver installed on your machine in the location which is as follow: C:\temp\new folder. The file we require for uninstallation is uninstall.exe, which can be found inside these folder. The sample command for the same is as below. Make sure to run the command from an elevated shell to avoid the UAC prompt. Command: C:\temp\new folder\Uninstall.exe /S  

1
Ankit Singh
8 months ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings