Overview
This smart service can be used to copy large amounts of data from one data source to another. It can come in handy when you need to copy the data from a table in the Appian cloud database to be stored in a local database.
Key Features & Functionality
Parameters
Notes
Hi, we tried running test using the plugin and sharing here is the error log from tomcat:
06:14:37.652 [Appian Work Item - 6847 - WorkID 233 - execution01 - process 268440750 - model 2333 : UnattendedJavaActivityRequest] ERROR copytabledata.MoveTableData - Error looking up from copy Table: Key is 12 (conn=661829) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '08:45:57.552,LNKCARD,2021-11-24 08:45:57.552,LNKCARD,5117,128000,6436,N)' at line 1
A further issue - if a column is named "value", it causes errors if it is not the last column.
A minor bug identified: if the last character is a backslash \, it needs to be escaped, else it is treated as escaping the closing double-quote, i.e. \", and therefore causing a syntax error
Thank you Naveen
Hi udayasai,
No, it will not support data migration to the synapse. This plugin will support only Appian supported databases.
will this support data migartion from appian internal db(maria db) to synapse? Because synapse db will not support jdbc drivers