Solved

I know I’m missing some fundamental context of query building - but I just want to cobble something together and could use a bit of assistance.I’d like to use the Google Sheets Excel Add-In, or even the ODBC Driver for Google Sheets, to pull some data down from a live aggregate that exists in one of our team’s Google Sheets - and automatically push it periodically into an Excel sheet. It’d be the entire contents of one sheet, read-only (mono-directional), placed into a named table in an Excel sheet - easy peasy. Or so I thought.I initially installed the ODBC driver, connected it successfully, but it only gives me a “This data source contains no visible tables” message. And since there aren’t really any options or configs, I bailed on that and installed the Add-In.With the add-in, however, I can only seem to get it to list my account’s folders, workbooks, and sheets.  I can’t actually get it to read the contents of a particular sheet. That is, only those three ‘tables’ are available - d

The standard documentation in https://cdn.cdata.com/help/AZH/mft/op_HTTPReceive.html shows the elements needed to use the httpReceive operation in scripting. Is there documentation or examples available to show the structure or syntax on how to use this operation?

We currently have configured Google Analytics 4 with custom dimensions. We want to get that custom dimension out of GA4 using the CDATA Google Analytics provider with Google Analytics 4 selected. We get data out of the correct property, so everything seems to be connected right. But these are all standards reports so it seems, I want to get custom data out of it.What should I do or what query can I use to get 1 custom dimension (customer_number), with 1 metric (event count) filtered by page_path contains 'example’ and another custom dimension (asm_user) <> 'null’?

Hi, I’ve been successfully using Sync to replicate data from Eleasticsearch index to Azure Data Lake. Now I have faced an issue one of index that is bigger than others (not much, but obviously enough bigger). In replication log there are following errors: [META|Cache ] Cache failed: Updating Row is failed. ERROR: Invalid HTTP response! Cannot upload PostData: System error: An existing connection was forcibly closed by the remote host., AffectedCount: 5200000 [SQL |Messag] Query Failed: [CACHE [uspa/spaiderloki/arkisto/2023] SELECT [_id], [Aika], [Atunnus], [Caller], [Callsite], [cdata_timestamp], [Duration], [Exception], [Filter], [guid], [ID], [kafka_partition], [Logger], [LogLevel], [Message], [Thread], [Version] FROM [Elasticsearch].[uspa-spaiderloki_arkisto_20233x]]. Error: Updating Row is failed. ERROR: Invalid HTTP response! Cannot upload PostData: System error: An existing connection was forcibly closed by the remote host., AffectedCount: 5200000 Updating Row is failed. ERROR: I

I’d like to do this Will it work? I get an error ”Error parsing Date value [now()].”

Is it possible to use the xpath formatter to get the name of the current element?Currently I am interested to get the name of the root element and get the content of an attribute on said element.

DataSource.Error: ODBC: ERROR [HY000] Specified cast is not valid.  i have 8 table in my database but if i connect to a specific table then it gives this error                                                                                                           DataSource.Error: ODBC: ERROR [HY000] Specified cast is not valid.Details:    DataSourceKind=CdataMongodb    DataSourcePath={"dsn":"CData Power BI MongoDB"}    OdbcErrors=[Table]

how can I access previous versions of a NetSuite JDBC driver. In particular I want to view the exact schema, data model for NetSuite JDBC Driver version 22.0.8322.0The latest/current version is JDBC Driver for NetSuiteBuild 23.0.8565https://cdn.cdata.com/help/DNJ/jdbc/ 

We upgraded DBAMp version on our SQL Server.Followed the instructions and created a new Linked Server. Stored procedures are running fine, but when I execute a SOQL query; we get the following error An invalid schema or catalog was specified for the provider "MSOLEDBSQL" for linked server "SalesForce". Example SOQL queriesSelect * from SalesForce...user__cSelect * from SalesForce...Account

Can i get the Twitter Connector API details for the Cdata platform ? 

Does anyone have any example Arc script that uses the fileReadLine operation to walk through an input file, parsing text line-by-line?

I have a REST Connector.On Error, I would like to Notify admins.I’d like to include the body of the Response in the email message. The documentation for the Notify connector says you can use ArcScript. But it doesn’t seem to do anything: The email I get isFile ES501_JE501_IN323078978944_ITMREF_20230720221100_20230720224809_47c0ddca-729b-43a6-833d-4466c9d422b11.json was routed to notification connector Notify2.<arc:set attr="in.file" value="[filepath]" /> <arc:call op="fileRead" in="in" out="out" > <!-- Here is where you can access the content of the file via the 'file:data' param. --> <arc:set attr="output.data" value="[out.file:data]" /> </arc:call>We attempted to send this to Atlas[output.data] How do I use ArcScript in the message?

When I use %Header:my-header-id% in the Btach Merge connector, I just get files called “.xml”Does this work?

We upgraded to DBAmp V22 version. Have upgraded the Stored Procedures.Regular SOQL queries work from the SQL server, but when try using SF_REPLICATE or SF_REFRESH we get the following error. --- Starting SF_Replicate for Account V830409:56:45: Parameters: SALESFORCE Account  Version: V830409:56:45: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc.09:56:45: Using options specified in Options parameter: soap09:56:45: Obtaining Connection Props09:56:46: Error: Unable to retrieve settings from sys_connection_props.09:56:46: System.Data.SqlClient.SqlException (0x80131904): Cannot get the column information from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)   at System.Data.SqlClient.TdsParser.TryRun(

Hello, I am trying to use CData Rest Task to call a Rest API from Azure DevOps.  The goal will be to pull the capacity information from the call.  https://dev.azure.com/AIZ-Global/_apis/projects/2ef0bfbb-5826-423d-a8e7-c970f2268f59/teams/64155638-69bf-4173-b301-2022f7bb356c/members?api-version=5.1When I enter the URI into the into URI field  under the connection section and select test connection I get the following error message.   I am sure that I am doing something wrong here but not being a developer I am a little lost here. Any help would be appreciate.  If you need additional information I would be happy to provide it. John Flood

 Any ideas?It doesn’t matter whether I choose “Export all...” or “Export Sensitive….”

I stumbled upon CData API Server, installed it, and was immediately impressed!  It seems to be a fantastic product - very simple and intuitive.  However, I was left with a few immediate questions:I can’t find any real documentation for it.  Is there some? Which forum should I use to post questions or look for answers? Can I change the naming convention of the resources created?  It appears they are named “[database]_[schema]_tableorview” by default.  I’d like to drop the “[database]_[schema]_”. Is there any kind of bulk editing action on the resources?  I have a lot of resources and I’d like to remove some operations on all of them.If the resources are controlled by some kind of config file (e.g. json or XML), and I can find it, I can probably do the bulk edits myself.Thanks in advance, and thanks again for a GREAT product!

Is this correct? 

I need to pick up from a different path each day, so I need to have paths like //SERVER/PathToRoot/ddmmyyddmmyy should be today’s date I see I can use %Header:xxxx% but I think that will only work for sending out file, not collecting files.Is there a way to set a Header when collecting files? Are there any examples using a script and fileListDir ?

Hi, We are migrating to new SQL 2022 servers.  I have installed v2022 of DBAmp on our new dev server, we use SF_Replication/SF_Refresh, changing to SF_Mirror is not yet on the table.  My default server collation is Latin1_General_CI_AS, and the DBAmp replicant also becomes this collation.  This is the exact same setup we run in production, with version 5.1.8.0 of dbamp.   Both environments, current prod and new dev have “Collation Compatible” and “Use Remote Collation” set to true.I have run a full SF_Replicate, and when i start to run the daily SF_Refresh i am getting the below error:--- Starting SF_Refresh for Contact V830416:12:31: Using Schema Error Action of subsetdelete16:12:37: Local table created at: 2023-05-17 16:29:0016:12:37: Using last run time of 2023-05-17 16:29:00Msg 468, Level 16, State 9, Line 1Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.--- Ending SF_Refresh. Operation FAILED.Msg 500

When I attempt to replicate ContentDocumentLink with CData Sync from Salesforce to SQL, I am getting this error. [0] [500] Could not execute the specified command: [sf:MALFORMED_QUERY] MALFORMED_QUERY: Implementation restriction: ContentDocumentLink requires a filter by a single Id on ContentDocumentId or LinkedEntityId using the equals operator or multiple Id's using the IN operator. The tool that I am looking to replace with CData Sync can do it.  Is there a workaround to get this object to replicate? Thanks

I’m seeing this in my logs [2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 2 [45|Q-Id] [META|Schema] Executing column schema query: [Shipment][2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send Begin - Length: 360[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send End.[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]DataIn, Length: 337[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send Begin - Length: 986[2023-07-10T16:25:14.617] [Info] [DRIVER] 2023-07-10T16:25:14.617+01:00 3 [Connection: 45]Send End.[2023-07-10T16:25:14.632] [Info] [DRIVER] 2023-07-10T16:25:14.632+01:00 3 [Connection: 45]DataIn, Length: 176[2023-07-10T16:25:14.632] [Info] [DRIVER] 2023-07-10T16:25:14.632+01:00 3 [Connection: 45]Send Begin - Length: 406[2023-07-10T16:25:14.632] [Info] [DRIVER] 2023-07-10T16:25:14.632+01:00 3 [C

 REST Connector: I need to pass the XML input filed in the GET method URL dynamically. ex: XML input to REST connectgor  <ZNA_SHIP_TRACK><IDOC><EDI_DC40>...</EDI_DC40><ZSHIP_RESPONSE><VBELN>7100124618</VBELN><ZAPI_KEY>922f65ee-093a-45fd-8f1f-c61c8050e67e</ZAPI_KEY></ZSHIP_RESPONSE></IDOC></ZNA_SHIP_TRACK>  REST API should be called with below URL in the GET method:EX: “https://www.client.shipmentstatus.com/api/cn/outbound_parcel_shipment/track?parcel_shipment_id=”  +  shipment ID value (XPATH(ZNA_SHIP_TRACK/ZSHIP_RESPONSE/ZAPI_KEY)value is https://www.client.shipmentstatus.com/api/cn/outbound_parcel_shipment/track?parcel_shipment_id=922f65ee-093a-45fd-8f1f-c61c8050e67e I have tried numeros method but dynamic URL is not created and throwing error.

1. ODBC Driver Download2. SQL Gateway

I am trying to connect my Neo4j Data with SQL server. I found that there are 2 options:1. CData Connect 2. CData ODBCBut for both I cannot connect my Neo4j Data. The following message is being shown:“Test connection failed. Error: Testing connection failed. Inner Error: Test Connection: Connection closed.”