Solved

Is there a way to set a default Schema to default to when saving information into SQL server?  I know how to do it by each table but find my self forgetting from time to time.

Hello Everyone, My name is Emmanuel Katto. I wanted to know what are the methods for achieving real-time data synchronization using CData connectors? Are there particular connectors better suited for this? Looking forward to your suggestions. Thanks in advance! Best,Emmanuel Katto

Good Day, Background:  Our current business requires that the Field History Tracking objects be replicated for reporting.  The initial replicate works, but the refresh we have scheduled to run hourly fails as the call to getDeleted returns 600000 or more deleted records - My initial thoughts are that these field tracking objects do not contain a SystemModstamp field and so DBAmp uses the data the table was created vs the last time the Refresh was ran (someone can correct me if I am wrong)I understand that there is a limitation of objects needing the SystemModstamp field for proper replication / refreshing but has anyone successfully replicated / refreshed (in a reasonable time interval) Field History Tracking objects? Any help would be greatly appreciated.

How to track which reporting balance row is deleted? because I am syncing record through Power automate. I am not able to track which row is deleted in reporting balance. if i get to know about that transaction I will sync that particular row related records again I am using cdata connect ai

:45:17.636-06:00  1  [42|Q-Id]  [META|Schema] Executed  column schema query: [App_History] Success: 4 results (268 ms)2024-09-10T21:45:17.636-06:00  2  [42|Q-Id]  [EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE  SchemaName = @schema AND  TableName = @table] Success: (268 ms)2024-09-10T21:45:17.636-06:00  2  [42|Q-Id]  [EXEC|Parsed] Executing query: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]2024-09-10T21:45:17.636-06:00  2  [42|Q-Id]  [EXEC|Parsed] Parameter: pk_b0 = 0f8a8d2f-1266-4f33-86ed-0d94f446125c2024-09-10T21:45:17.636-06:00  5  [42|Q-Id]  [META|Schema] Engine Invalid object name 'App_History'2024-09-10T21:45:17.636-06:00  3  [42|Q-Id]  [TCP |Send  ] Send Begin - Length: 2742024-09-10T21:45:17.636-06:00  5  [42|Q-Id]  [TCP |Send  ] [SQL |Messag] Query Failed: [SELECT TOP 100000 * FROM [dbo].[App_History] AS [WITH] WHERE [ID] > @pk_b0 ORDER BY [ID] ASC]. Error: The SQL Error Number is 102

2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [SQL |Cache ] Cache failed: [500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]2024-09-10T00:52:03.708-06:00    0    [6|Q-Id]    [SQL |Cache ] Replication Failed. Error:[500] Could not execute the specified command: Name Tool ID# not found inside D at [1:97]2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:System.Data.CData.SQL]The connection is disconnected.2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:GoogleBigQuery]The connection is disconnected.2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [RealDB:SQLite]The connection is disconnected.2024-09-10T00:52:03.708-06:00    1    [6|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [tools_data_testing] WITH _id = '5a2DAIBt+eVwYnh0y2b6zA==' SELECT [Access Method] AS [access_method], [Actively Selling] AS [actively_selling], [Actual Deployment Date] AS [actual_deployment_date], [Additional Languages] AS [additional_languages], [AKA N

When I use the EDIFACT connector for sending the outbound EDIFACT messages, there is option to enable to include Test Indicator, thus it include “1” as test indicator at UNB 11.UNA:+.? 'UNB+UNOC:2+ZZLINFOXSIP:ZZZ+9500SCJID:ZZZ+240913:0829+000000007++INVRPT++++1'UNH+0002+INVRPT:D:98B:UN' Once we move the code to Production environment, I have to disable the Test Indicator since this is Prod files, but the UNB11 dosen’t populated with “0”. UNA:+.? 'UNB+UNOC:2+ZZLINFOXSIT:ZZZ+9500SCJIDTEST:ZZZ+240913:1140+000000186++INVRPT'  à missing the Prod Flag “0”.UNH+121+INVRPT:D:98B:UN'  Please advise is there any option I could be able to populate the Prod Flag.

5 days back  I get rows from Reporting balance and stored in one excel again I fetch same rows from reporting balance but i noticed that ID is changed for some rows Eg :228473716 where previously for one row but the same row ID is differed now like 2284765654Based on GLAccountCode Division and Reporting year I am fetching the rows any reason for this ? how to track this which row is changed ?Thanks

I’m encountering an error in CData Sync when I try to create and test a source connection. The complete error message is Connection open failed: [500] Failed to login 'SERVERNAME', Cannot open database 'DBNAME' requested by the login. The login failed. Login failed for user ‘user’. What is the requirement for the SQL server so that CData can establish a connection? Also, are there any logs in CData we can check that has more details about the error?The documentation does not say anything required from the source other than the server and login credentials.

I have GL Account Classification Mapping In Dataverse Table i used automation to pull data from Exact online and pushed data into dataverse . I need help on how to track that GLSchemeCode Changes from previous version  to updated version Eg:RGS versie 3.3 to RGS versie 3.5 in overtime because based on this updation in exact online I want to update the same thing in dataverse table  how to track this change and update accordingly ?

We are currently implementing CData to sync to a data warehouse. I’m not non-techy guy on the team and we’re trying to figure out the tables and views that are listed in the Sage Intacct Connector for CData Sync - Data Model.Are these the only tables/views available? Also, what’s the different between a table and a view? Why would a Gldetail and Glentry view, which should have the same columns, be different?Thanks!Steven

I’d like to get information if certain job finishes successfully, but 0 rows are replicated. I found snippet that send email, but how can I write an “if query” that catches only  those scheduled jobs that I want? There is snippet template for that, but I don’t understand how it need to be modified <!-- Enumerate Through Query Results --><api:enum prefix="Query#"><api:set attr="temp.index" value="[_index]" /><api:set attr="temp.query" value="[_value]" /><api:set attr="temp.status" value="[QueryStatus#[_index]]" /></api:enum>  

from which table we can check what are GLAccount code linked for a particular Division ? 

Hi, since two weeks we are getting error when replicating all of our salesforce objects. The error does occur randomly not specific to an object. See error example message:--- Starting SF_Replicate for ContentWorkspaceDoc V8641 [SQLSTATE 01000]16:21:52: Parameters: [LS_SALESFORCE_PROD] ContentWorkspaceDoc Version: V8641 [SQLSTATE 01000]16:22:20: Running DBAmpAZ.exe. [SQLSTATE 01000]16:22:20: DBAmpAZ 22.0.8642.0 Copyright © 2023 CData Software, Inc. [SQLSTATE 01000]16:22:20: Using options specified in Options parameter: soap [SQLSTATE 01000]16:22:36: Error: Unable to open a connection to SQL Server. [SQLSTATE 01000]16:22:36: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) ---> System [SQLSTATE 01000].ComponentModel.Win32Exception (0x80004005): The wait operation timed out [SQLSTATE 01000]at System.Da

Hi,I’m exploring the capabilities of CData Virtuality for our use, and am unable to find any information on support for delta lake on Azure Data Lake Store as a source. I don’t see any CData drivers for it either. Is this not a supported source? If not, is it on the roadmap? Thanks.

Hello,I will really appreciate your help with below question related to version upgrade.Our team is planning to upgrade DBAmp version from  4.1.8.to V2022.While going thorugh release notes ,came across with statement:“Using DBAmp with SSIS has been removed. We recommend you use the CData SSIS product.” Does it means that,We will not be able to execute DBAmp  SQL server stored procedures through SSIS packages that we have installed on our side that we are using currently?  If yes,what we can use,do we need to buy some new product. Thanks You  

Hello,I will really appreciate your help with below question related to version upgrade.Our team is planning to upgrade DBAmp version from  4.1.8.to V2022.While going thorugh release notes ,came across with statement:“Using DBAmp with SSIS has been removed. We recommend you use the CData SSIS product.” Does it means that,We will not be able to execute DBAmp  SQL server stored procedures through SSIS packages that we have installed on our side that we are using currently?  If yes,what we can use,do we need to buy some new product. Thanks You  

Hi,I have set Additional Options to TransactionSize=100 and Batch Size to 50 in the Job’s advanced section. My understanding is that setting a Transaction Size will commit the rows at whatever number is assigned, so in my case when 100 records have been cached, those are committed to the database.Unfortunately, the job is not saving any records to the Microsoft SQL destination table for one of the source tables. When I turn on verbose logging, I can see in the logs that 10000+ records have been cached, because I can see the data from those records in the log file. There are other tables which are successfully being populated. Just this one is not. When it errors out at some 20kish row the job ends and there is no data in my destination table. How do I make the job save data it is caching to the table before the error is thrown?

Hi All,I am trying to connect my dynamics GP web services through python but I am unable to do so. I was working out the basic code given on their website and still unable to work it out. Could you advise any probable solution for it?ERROR:cdata.dynamicsgp.DatabaseError: [500] Could not execute the specified command: Failed to log into Dynamics GP Server, please check your settings. Error message: HTTP protocol error. 404 Not Found.

Hi,I don’t see a connector for “delta lake” on Azure Data Lake Store Gen2. Is this not a supported source? If not, is it on the roadmap? Thanks.

CData Arc™ 2023 - 23.4.8789.0 I’m trying to use a SQL Server Lookup to determine if a matching record exists or notHere are my settings    If I use “Use NULL Value” I do not get the Lookup-consignmentno header at all.If I use “Use Empty String” I get an Error “Lookup: Field cannot be null”In the logs I get [2024-07-11T11:23:07.371] [Info] SQLCommand: SELECT `consignmentno` FROM `woodside`.`pallettrackduplicateprevention` WHERE (`consignmentno` = @p1); @p1='EPB0925'[2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+01:00 2 [3553|Q-Id] [EXEC|Parsed] Executing query: [SELECT [consignmentno] FROM [woodside].[pallettrackduplicateprevention] WHERE [consignmentno] = @p1][2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+01:00 2 [3553|Q-Id] [EXEC|Parsed] Parameter: p1 = EPB0925[2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+01:00 3 [3553|Q-Id] [TCP |Send ] Send Begin - Length: 242[2024-07-11T11:23:07.371] [Info] [DRIVER] 2024-07-11T11:23:07.371+

I found out that I need Tableau Bridge in order to “bridge” my CData ODBC driver with Tableau Cloud. Do you have any instructions you can share?

I have a lot of data in my data source that I am trying to use with Tableau. When using CData connectors, is there a way I can help improve performance by only pulling in changed data?

Hello all,The company I work for has added a service to the CData SQL Gateway application.This service is linked to a data source that changes during the day. I have found that the service needs to be restarted in order for changes to appear that I need to work on.Is there a way to automatically restart a service without having to click on this button?I.e. is it possible to restart a CData SQL Gateway service from the command line? That way I can create a batch script to do this.Any help would be greatly appreciated.Thanks,Adam

Good morning everything is fine?Using the FireDAC Excel component, is it possible to freeze the first row and add filters to the columns?Thanks.