Skip to main content

CData Drivers & Connectors

Share product questions and get support for CData Drivers & Connectors

  • 116 Topics
  • 215 Replies
116 Topics
S
schildersApprentice
asked in CData Drivers & Connectors
Is it Possible to Insert Checks into QuickBooks Desktop using the QuickBooks Destination?

I’m evaluating the QuickBooks Destination SSIS connector and have a specific use case of inserting checks into QuickBooks from an OLEDB source query.  When mapping the fields from the query, I noticed that the QuickBooks Destination depicts the Check Amount field as read only.  Is there a workaround that would allow me to insert new check information into QuickBooks Desktop Premier 2020 to include the check amount?

3
Ethem Q
6 months ago
D
db_maverickApprentice
asked in CData Drivers & Connectors
Cassandra to MySql RDS

HI,Is there a direct path available to migrate data from Cassandra to MySQL RDS on AWS??

1
Ankit Singh
6 months ago
garybray
garybrayApprentice
asked in CData Drivers & Connectors
odbc error hy000 using PowerBI

Have a user that gets the following error when trying to refresh the data & import more data using PowerBI.  How can I remedy this for her? 

5
Ethem Q
7 months ago
taranr_sockeye
taranr_sockeyeApprentice
asked in CData Drivers & Connectors
Cdata: PowerBI + Sage Intacct Performance

Hi!Two pronged question. What’s typical performance that should be expected with Cdata’s Sage Intacct / Power BI connector? [I’m getting about 250k rows loaded from a large data set in an hour] Are there any tricks / tips to enable faster load times for large data sets? If I want to say download the GL-Detail table from Sage intacct, waiting 4+ hours to get the information is sometimes a hard ask.Thanks in advance!

4
taranr_sockeye
7 months ago
C
carmel.ronNewcomer
asked in CData Drivers & Connectors
Salesforce driver - json data

I upgraded the Salesforce JDBC  driver from version 21 to 23.There is a difference in behavior between the 2 versions : I execute this query and get different results: SELECT User.Name FROM User On version 23:{  "Name": "Carmel"} On version 21:“Carmel”Is this the expected behavior? Is there a fix for it? 

1
Ethem Q
7 months ago
K
KevinApprentice
asked in CData Drivers & Connectors
Attribute id is required by quickbooksadodesktopupdate

Quickbooks - ODBC call is failing when trying to update a column using a Passthrough query in MS Access. It appears to only fail when there are multiple records to update. Works fine with a single record. SQL string looks like this:UPDATE SalesReceiptsSET DepositAccount = ‘Checking’WHERE Date=’2024-01-01’;Persistent connection is ENABLED  

1
Ethem Q
7 months ago
R
RichardGardnerApprentice
asked in CData Drivers & Connectors
Get data from a sub folder of a shared mailbox in Exchange

Im trying to design a select query to get the email items in a Inbox subfolder of a shared mailbox when using the Exchange ODBC driver (Exchange online/Office 365). I can get to the shared folder inbox but not query the subfolder. Can anyone help me figure it out please?

1
Ethem Q
7 months ago
Z
zach gApprentice
asked in CData Drivers & Connectors
Power Automate to Update Snowflake Data table from SharePoint list

I’m wondering if there’s a way to leverage Power Automate to automatically update data tables within Snowflake every time a sharepoint list is updated?

1
Ethem Q
8 months ago
P
PhilippeApprentice
asked in CData Drivers & Connectors
Connectors Release notes

HelloWhere can I find the connector release notes (fix, improvements...) depending on their version?Thanks

1
Ethem Q
8 months ago
Q
quangdutran809Collaborator
asked in CData Drivers & Connectors
SQL Analysis Services JDBC Driver detects all column as VARCHAR

Hi Cdata folks,Cdata driver latest version v23Weird thing is that SQL Analysis Services JDBC Driver detects all column as VARCHAR no matter what type of the model column: This is the model in Visual Studio: Before importing, the data type is also detected correctly in Visual Studio:   But in meta data, type for all columns is VARCHARThis is how I get the metadata:Connection conn = DriverManager.getConnection("jdbc:ssas:AuthScheme=BASIC;User=user;Password=pwd;URL=http://HOST/OLAP/msmdpump.dll;");Statement stat = conn.createStatement();DatabaseMetaData databaseMetaData = conn.getMetaData(); try(ResultSet columns = databaseMetaData.getColumns("TabularProject3","Model","Table","integer")){ while(columns.next()) { System.out.println(columns.getString("COLUMN_NAME")); System.out.println(columns.getString("DATA_TYPE")); System.out.println(columns.getString("COLUMN_SIZE")); System.out.println(columns.getString("TYPE_

1
E
8 months ago
Q
quangdutran809Collaborator
asked in CData Drivers & Connectors
Azure Analysis Services JDBC Driver does not return any tables/schema data

Hi team, I have connected to AAS successfully using jar file:  But when I try to fetch data, nothing is returned. For example getting the metadata:ResultSet columns = databaseMetaData.getColumns(null,null,null,null)Or select from system tables:statement.execute("SELECT * FROM [sys_schemas]");They all return nothing, empty result set.Why?

4
Q
8 months ago
V
VonukuriAnushaApprentice
asked in CData Drivers & Connectors
How to connect to AmazonS3 from Spotfire directly

Hi,I need to establish a direct connection from AmazonS3 to Tibco Spotfire, I have searched in this portal got a  ODBC driver but i am not able to download and it is asking Product key, is there any other way we can connect directly, and also how do i get product ket details is it licensed one, if it is license what would be the cost?

1
Ankit Singh
9 months ago
R
rocketmaniacApprentice
asked in CData Drivers & Connectors
DataTable.Remove/Delete do not seem to be working ADO.NET Provider for Presto

PrestoDataAdapter dataAdapter = new PrestoDataAdapter("SELECT _id FROM hive.transactional_schema.[TableName]", connection);dataAdapter.DeleteCommand = new PrestoCommand("DELETE FROM hive.transactional_schema.cached_reports where _id = @_id", connection);dataAdapter.DeleteCommand.Parameters.Add(new PrestoParameter("@_id", DbType.String, "_id"));DataTable table = new DataTable();dataAdapter.Fill(table);DataRow[] rowsToRemove = table.Select("_id = '657636888a673e46b8a4dce0'");foreach (var rowToDelete in rowsToRemove){ //table.Rows.Remove(rowToDelete); rowToDelete.Delete();}table.AcceptChanges();dataAdapter.Update(table);I’ve tried both Remove and Delete and neither ends up executing a DELETE query on the Trino server, even though the DataTable shows the row as deleted.

4
R
9 months ago
D
dean.roeserApprentice
asked in CData Drivers & Connectors
Syncing ASP.NET CData Driver Versions Between Multiple Developers

Hello! I work for an ETL service that builds some of its connectors based on CData drivers. We now have multiple developers trying to work on these connectors, some of which were built based on older CData drivers. However, when a new developer downloads the latest driver, it causes incompatibility issues if there have been major changes. Is there any tool for version control for CData drivers that is available? Is there another solution that can solve this problem? Is there any way to download older versions of the drivers? Thanks!

1
Ankit Singh
9 months ago
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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
9 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
10 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
10 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
10 months ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings