Ask questions, get answers and engage with your peers
Start discussions, ask questions, get answers
The latest CData product news and updates
Explore and RSVP for upcoming events
Guides, documentation and support articles
Share product questions and get support
Join a group and share common interests
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
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?
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!
If we configure DBAmp to use a remote server (e.g. Azure managed SQL), does all data flow through the server where DBAmp is installed? And if so, what is the transport-layer security between the DBAmp-server and the remote server?
Getting the following error after executing: SELECT * FROM [<linked_server_name>_Fields]: “EXCEEDED_ID_LIMIT: EntityDefinition does not support queryMore(), use LIMIT to restrict the results to a single batch” This error means exactly what it states. An API request to the EntityDefinition table is made. When getting results from the table, the query() method is executed from the API. It has a limit on how many records the result query object can contain. If the limit is exceeded, the queryMore() method is called by the API to get the next batch of data. But this specific Salesforce Object (EntityDefinition) does not support the queryMore() method, which then results in the above error returned from the Salesforce API. In pre-V22 versions of DBAmp, one way to get around this restriction would be if the _FieldsPerObject system view created by the stored procedure SF_CreateSysViews, is used for each object individually. For versions V22 and higher, a stored procedure, SF_SysSF
Our users are using Oracle smartview for financial reporting and are looking for an excel based tool to have similar capabilities in BigQuery. I wanted to know if CData plugin for excel can do the below:Slice and dice data based on BigQuery data models Consume hierarchies maintained in bigquery. For example a legal entity hierarchy that would be maintained centrally in BQ and consumed in financial reports Schedule reports Do cell based formulas. So for example, I want to create a forumla that goes into a cube and returns net earnings for the year input by the user in one of the cells.
I am setting up a new trading partner to send EDI X12 850 and they keep coming back to me saying “we received your file but it is not processed with octet-stream. Please send as EDI-X12”.My X12 connector is setup and working just like the dozens of other trading partners.This is a screen shot of what they are sending me:I checked the Advanced settings on my X12 connector and didn’t see where the application/octet-stream is being set. I tried adding payload=application/edi-x12 on my AS2 Extension map to no avail.Any ideas would be appreciated.
OAuth 2.0 Overview In today’s standards, OAuth 2.0 is becoming increasingly popular as a means to authorize users who are attempting to access a resource, be it a mail server, API endpoint or database. A common example of this shift is the deprecation of basic authentication in Exchange Online (Microsoft’s mail server for Outlook), which can be read about in more detail in Microsoft’s article, here.OAuth 2.0 is an authorization protocol and not an authentication protocol; a means of granting users access to a set of resources - in the case of what is discussed here, that resource would be a mail server.At a very high level, OAuth 2.0 can be summarized in the following steps: The connecting client acquires both a client ID and a client secret from the authorization server. The client requests to be authorized by the authorization server by providing their client ID and client secret. Additionally, any necessary scopes and a redirect URI are also provided. If the supplied credentials
CData Arc Newsletter Our team has been focused on making your work within CData Arc easier and more streamlined in our Q4 2023 product release. These features include an improved Lookup action, a new dashboard view of “today,” visual formatting of XML and JSON previews, and more. Check out what’s new, get a sneak peek into the future, and more in our latest newsletter.Read on for more details! Discover Arc’s new features in just a few minutesWant to quickly hear what’s new with CData Arc? Our 2-minute video shows off how each feature update makes no-code B2B integration easier.Watch the video A deep dive into LookupsWhy did our product team improve CData Arc Lookups? Why are they useful? How can you configure and perform a Lookup? Get all this and more, along with an example Lookup scenario in our recent CData Community article.Read the article TechTarget names Arc the #1 product of its kindTechTarget’s recent Data Quadrant report puts Arc at the very top of its category! 93% of Arc
In .NET Core applications, when handling data with a character set that is not bundled with .NET Standard, you may come across the following error message: “Unable to translate bytes [..] at index x from specified code page to Unicode”. To resolve this issue, you will need to install the System.Text.Encoding.CodePages dependency Install-Package System.Text.Encoding.CodePages , and add the following line of code to your application at the start of your code: System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); In the following example, I have used the CData ADO.NET Provider for Amazon Marketplace to create a connection to our Japanese Amazon Marketplace account in Entity Framework Core 6.0 (please consult the “Getting Started with EFCore” section of the driver’s documentation: https://cdn.cdata.com/help/ONJ/ado/pg_efCoreOverview.htm ). The API’s charset is charset=Windows-31J: This character encoding isn’t supported by default in .NET Core, hence
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_
Hi, So I have a system with CDataSync to sync my data from SQL Server to Azure Synapse with below detail: Old System:CDataSync Version: 22.0.8342.0CData AzureSynapse Provider Version: 22.0.8326.0 New System:CDataSync Version: 23.3.8704.0CData AzureSynapse (23.0.8616.0) I backup the old configuration and restore it to new configuration. However, it keeps getting an error like this Error: The SQL Error Number is 103010, State is 1, Severity is 16, Error is 'Parse error at line: 1, column: 126: Incorrect syntax near '.'.', Server name is server1, Line number is 1. The Token Type is 170. I found that the task is successful when I use this conditions:I dont use a new scheme for the destination, but I checked the Drop Table/Truncate Table I use a new scheme, but I unchecked the Drop Table/Truncate TableIs there a new query or options that changed in the new version? What can I do to fix the error? Thank you
Explore e-Books, whitepapers, webinars and more!
Contact our support team and we'll be happy to help you get up and running!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.