Solved

Hi I want to trigger a simple flow using a webhook. When I call it via PostmanPOST /connector/AtlasTrackingToServiceBus/Webhook1/webhook.rsb HTTP/1.1Host: jpREDACTED01:80XXContent-Type: application/xmlAuthorization: Basic RGF0-REDACTED-5eTFnContent-Length: 13<root></root>I’m not interested in the message body, I just want to trigger the flow I can see the Webhook being triggered and that looks SUCCESSful. The Webhook flows into a MySQL Connector, but the MySQl Connector reports that the message is not “Finalised” [2024-01-08T11:38:56.632] [Info] Arc Version: 23.3.8698.0[2024-01-08T11:38:56.632] [Info] System Version: Microsoft Windows Server 2022 Standard[2024-01-08T11:38:56.632] [Info] VM Version: 4.0.30319.42000[2024-01-08T11:38:56.632] [Error] The message Webhook1-20240108-113856335-cK_v is not finalized.[2024-01-08T11:38:56.632] [Info] Message Webhook1-20240108-113856335-cK_v is finalized. Name: Webhook1-20240108-113856335-cK_v.xml, Type: Input, Status: Error, Message:

Hi Folks,Good to be part of this group. I recently started using Cdata to load reports from Netsuite for one of my clients. As we load the Sales Oreder table using SuiteTalk, we find that the item column is not available in the preview. What could be the reason for this? We are at an impasse right now as it’s imperative we get the item field. Initially we thought it was an access issue with the Cdata user, but we have ensured that our user has all the necessary permissions to load this data. 

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_

You can use post-job Events to run some arbitrary SQL (like a stored procedure) at the end of your Job.The documentation says you have to make your own connection, as below.  But I’d really rather not embed cleartext credentials in multiple jobs.  Is there a way to specify a CData connection (which we’ve already established at this point), in the Event?What I’d really like is the ability to run arbitrary SQL commands against the target table, after each Task completes, not just at the end of the Job.  Seems like this could be a parameter that we supply as we define each Task.<api:set attr="db.driver" value="System.Data.SqlClient"/> <api:set attr="db.conn" value="Data Source=sqlserver;Initial Catalog=Test;User ID=user;Password=pass;"/> <api:set attr="db.query">INSERT INTO MyLog (JobName, RunDate, Results) VALUES ('[_input.JobName]', '[null | now()]', '[_input.JobStatus]')</api:set>

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?

Using CData Sync Cross Platform with Workday WQL connection. Some queries work successfully, but a bunch fail with this message:[0] Received error from Workday: Invalid WQL query: !**! This error occurred during a request to calculate the field !**!, for instance !**!.. Cause: com.workday.exceptions.ExternalFieldException: The Increment or Decrement Date field, !**!, has encountered a blank date..  Thanks.

Trying to connect to Min.io on-prem S3 bucket. Confirmed API is working:  However, I don’t know how to point to https://nas2.piorl.us:9000/bucket1/ in CDataSync Cross-Platform Edition. I’ve tried defining the full path in the Bucket field as well as “Path” in advanced options, but neither want to work. There is a reference to a “Custom URL” field in the advanced connection properties, but I can’t find the variable anywhere:  Thanks.

I am using the Copy connector to make a copy of all EDI 810 for a trading partner and sending them to another workspace where I need to find a group of 200 possible unique matches and route them to another trading partner.  As you can see in the screen shot below, I know what file name(s) to look for and therefore began this new flow using the Branch connector.  The values I’m looking for in the filename will always match a specific pattern.  However, the branch connector is going to be MASSIVE if I manually add 200 possible filename patterns. (this image shows only 6)Besides being tedious, this method will work but I am wondering is there a way to script this?  Regardless, I will still be hard-coding 200 filename prefixes.  Thanks

My lookup looks like this `/Items/tracking_events/parcel` node does not exist. Only /Items/tracking_events existsWhen I run the connector I don’t get a parcel or a barcode node.I have also tried /Items/tracking_events/parcel_barcode.Does the XML node have to exist in the incoming message? I can extract the barcode to a message header okay.

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?

Hi I have a complex MySQL query with several JOINs need to only fetch new data from the tables. I have read https://cdn.cdata.com/help/AZH/mft/Database-AC.html#only-process-new-or-changed-records but not sure how to apply this to a Custom Query, Can custom queries us data from the message header? If so I may be able to use the method James suggested at  

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

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 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

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.

I’m attempting to add a task to an existing job and get an error:“The job <job-name> contains an unlicensed connection: Only 10 tasks are allowed in the Job” I also tried creating a job from this existing job and got an error:The connection [Salesforce_abc] is unlicensed: Unlicensed connections cannot be shared across multiple jobs. We have an Enterprise license, and my job is using SalesForce as a source and Azure SQL as a destination. I tried adding a task to a different job that uses Salesforce as source and Azure SQL as destination, and it worked.

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?

Hi all, I’m trying to create a mapping to translate a CSV format with parent-child rows into a flat CSV format. My source file is structured like this:Row Type Order number Customer name Total Cost Header 12345 John Smith $15.00 Row Type Item code Item name Cost Line 40123 5mm cable $5.00 Line 40124 10mm cable $10.00 Row Type Order number Customer name Total Cost Header 12346 Jane Lane $10.00 Row Type Item code Item name Cost Line 40124 10mm cable $10.00  Note that the actual file does not have headings, so looks like this:Header 12345 John Smith $15.00 Line 40123 5mm cable $5.00 Line 40124 10mm cable $10.00 Header 12346 Jane Lane $10.00 Line 40124 10mm cable $10.00  I am wanting to convert this to a flat CSV structure that combines data from the parent header and child line rows. So the above would be translated to:Order number Customer name Item code Item name Cost 12345 John

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 

Below the query is would like to run.It is supposed to select rows from the contactcollectiontable and exclude records based  statusecode and on multiple values in the FunctionCode column.$where = "StatusCode = '2' and FunctionCode<>'Z14' and FunctionCode<>'Z95' and FunctionCode<>'Z96' and FunctionCode<>'Z97');" $A = Select-SAPHybrisC4C -Connection $conn -Table "ContactCollection" -Columns $Columns -Where $WhereHowever the code above is not working and throws this error:Select-SAPHybrisC4C : [500] Could not execute the specified command: [ERROR] Error in filter System Query, Operation failed::Expression can not converted into ABAP select options. At line:2 char:6+ $A = Select-SAPHybrisC4C -Connection $conn -Table "ContactCollection" ...+      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~    + CategoryInfo          : OperationStopped: (CData.SAPHybris...HybrisC4CSelect:SAPHybrisC4CSelect) [Select-SAPHybrisC4C], avx    + FullyQualifiedErrorId :