CData Drivers

Hi everyone! I would like to know if is it possible to retrieve data from the SAP ECC 6.0 Function READ_TEXT, using the CData SSIS Components for SAP ERP 2023. Thanks.

Hi Tech Support,I am currently testing your ODBC Connector to Business Central. I managed to connect to Business Central. What I noticed was that the connection was returning all the different divisions that we have on the server. We use the connector to link an SQL Server (as a linked server) but it created a problem. We have multiple tables with the same name which I think it is normal all the different divisions have exactly the same structure tables and field names.So I decided to create multiple ODBC connections, each of them pointing at a different division (on the company field of the connector). This filtered out perfectly the different divisions.The problem is that on the “CData SQL Gateway” I can only start the connection with one of them (that happens to have the default name of “CData D365BusinessCentral Sys”) They are configured exactly the same, using different ports but pointing at different divisions (Company).On the users

Hi Ethem,thanks for your replay, i have updated the latest drivers in my system. after that i can see the WQL extension objects. all objects i can see but however i am seeing some more problem in this query i am attaching error image for your reference. and also one more is, please suggest how to get all the objects listed in workday, same like in sql server usually SELECT * FROM information_schema.Tables sintax used to get all objectssimilar kind of thing any sintax is it available in Workday? kidnly advise.   

Hi Folks, Please help to advice what will be the max number of files / max Workers a connector will be utilized in a time, since many time i could see files getting stagged up for few hours not getting processed. Then manually sending the files also take time to process, but the server CPU utilization is in optimal level. This causes the business team unable to receive files in time and causing issues,  above is the example from today 9.27 AM MYT files got queued up and not processed for nearly 1.5 hrs. Now i am manually processing them. This is simple Copy Connector. 

Hi Team, while connecting Workday Cdata SSIS connector below error is coming kidnly advise.“Invalid FROM clause starting with character: 6405. Invalid WQL syntax.”i am using below query from workday.select * from creditcardtransactionswhere "company_Prompt" = 'LE020 Redwood Software, Inc.' 

HiIs support for the new objects in Salesforce’s Non Profit Cloud (NPC) built into the latest version of dbamp; this would be for objects like GiftTransaction, etc?If not, is there a timeline to provide support?Many thanks

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?

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

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? 

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!

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? 

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  

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?

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?

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

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();

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?

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?

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.

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!

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 updat

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?

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?

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?

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