# CloverDX Platform **URL:** https://forum.cloverdx.com/c/cloverdx/5.md [Latest](https://forum.cloverdx.com/latest.md) · [Categories](https://forum.cloverdx.com/categories.md) --- ## [About the CloverDX Platform category](https://forum.cloverdx.com/t/about-the-cloverdx-platform-category/10)
**Author:** [@PavelSvec](https://forum.cloverdx.com/u/PavelSvec)\ **Replies:** 0\ **Last updated:** [November 5, 2024, 2:04pm UTC](https://forum.cloverdx.com/t/about-the-cloverdx-platform-category/10 "2024-11-05T14:04:23Z")
The one and only category dedicated to CloverDX Platform usage related posts. Feel free to ask questions or share your own CloverDX experience. --- ## [Welcome to CloverDX Forum! 👋](https://forum.cloverdx.com/t/welcome-to-cloverdx-forum/5)
**Author:** [@system](https://forum.cloverdx.com/u/system)\ **Replies:** 0\ **Last updated:** [October 3, 2024, 5:03pm UTC](https://forum.cloverdx.com/t/welcome-to-cloverdx-forum/5 "2024-10-03T17:03:13Z")
CloverDX Forum This is a place where you can share all your CloverDX and data related experiences. Here are some things you can do to get started: :speaking\_head: Introduce yourself by adding your picture and informa… --- ## [Integrating Museum POS Data with Membership and Visitor Systems](https://forum.cloverdx.com/t/integrating-museum-pos-data-with-membership-and-visitor-systems/3324)
**Author:** [@tepos\_clint](https://forum.cloverdx.com/u/tepos_clint)\ **Replies:** 1\ **Last updated:** [August 13, 2026, 8:29pm UTC](https://forum.cloverdx.com/t/integrating-museum-pos-data-with-membership-and-visitor-systems/3324 "2026-08-13T20:29:19Z")
Hi everyone, I’m exploring a data integration setup for museums where the POS system needs to work alongside membership, ticketing, CRM, and visitor-management systems. A typical museum may have POS transactions from t… --- ## [Mass Update Listener Errors](https://forum.cloverdx.com/t/mass-update-listener-errors/3312)
**Author:** [@Tamara\_Rosenberger](https://forum.cloverdx.com/u/Tamara_Rosenberger)\ **Replies:** 3\ **Last updated:** [June 23, 2026, 9:10am UTC](https://forum.cloverdx.com/t/mass-update-listener-errors/3312 "2026-06-23T09:10:04Z")
We have over 300 Event Listeners that errored out while updating the server. Is there a way we can mass update these instead of resetting the state one by one? --- ## [Query about look up joins - Join keys](https://forum.cloverdx.com/t/query-about-look-up-joins-join-keys/3307)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 3\ **Last updated:** [April 22, 2026, 6:50pm UTC](https://forum.cloverdx.com/t/query-about-look-up-joins-join-keys/3307 "2026-04-22T18:50:17Z")
Dear Forum Members I have a look up table which i have created and i have two join keys i.e. “SupplierID” and “ProductNo”. When we do look up join do we have to have the same name column to do the join? I am having an … --- ## [Write fieldnames when using append with the FlatFile & Spreadsheet Writer does not work?](https://forum.cloverdx.com/t/write-fieldnames-when-using-append-with-the-flatfile-spreadsheet-writer-does-not-work/3302)
**Author:** [@Michel\_van\_Gent](https://forum.cloverdx.com/u/Michel_van_Gent)\ **Replies:** 2\ **Last updated:** [February 9, 2026, 12:45pm UTC](https://forum.cloverdx.com/t/write-fieldnames-when-using-append-with-the-flatfile-spreadsheet-writer-does-not-work/3302 "2026-02-09T12:45:37Z")
Hi! I am trying to write some aggregated data to a file using the FlatFileWriter and then add all records as details to the same file using a second FlatFileWritter having a higher phase with the setting to append. I h… --- ## [Erroring out reading huge data](https://forum.cloverdx.com/t/erroring-out-reading-huge-data/3277)
**Author:** [@Balaji\_R](https://forum.cloverdx.com/u/Balaji_R)\ **Replies:** 2\ **Last updated:** [February 4, 2026, 8:14pm UTC](https://forum.cloverdx.com/t/erroring-out-reading-huge-data/3277 "2026-02-04T20:14:34Z")
Hi, I’m facing some issue while trying to read the flat file lets say csv which is of 47.5 GB in total size , trying to read this file and filter on based on some condition and loading into respective database table. Bu… --- ## [Processing several files - one at a time](https://forum.cloverdx.com/t/processing-several-files-one-at-a-time/3287)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [November 6, 2025, 5:05pm UTC](https://forum.cloverdx.com/t/processing-several-files-one-at-a-time/3287 "2025-11-06T17:05:19Z")
Dear Forum Members, I have a graph which works on a single file. I wanted it to work for multiple files but one at a time. I have tried using ListFile component to list all the files in the source folder but unable to … --- ## [Create record structure within CTL2 code](https://forum.cloverdx.com/t/create-record-structure-within-ctl2-code/1671)
**Author:** [@etl\_1234](https://forum.cloverdx.com/u/etl_1234)\ **Replies:** 3\ **Last updated:** [August 27, 2025, 7:40pm UTC](https://forum.cloverdx.com/t/create-record-structure-within-ctl2-code/1671 "2025-08-27T19:40:57Z")
Hi, I am trying to find the way to create record type within CTL2. Currently, we have following record structure in Ab Initio : record decimal(10) abc; decimal(10) xyz; end \[int\] test = allocate; Here we want to ha… --- ## [Issue with Sending Integer Value via Multipart Entity in HTTP Connector](https://forum.cloverdx.com/t/issue-with-sending-integer-value-via-multipart-entity-in-http-connector/3272)
**Author:** [@Peter\_Baan](https://forum.cloverdx.com/u/Peter_Baan)\ **Replies:** 2\ **Last updated:** [August 20, 2025, 12:08pm UTC](https://forum.cloverdx.com/t/issue-with-sending-integer-value-via-multipart-entity-in-http-connector/3272 "2025-08-20T12:08:46Z")
Hi, I’m currently working on performing a POST request to an API using the HTTP Connector component with a multipart entity. Based on the edge and the data I need to provide to the API, I’ve configured the correct fiel… --- ## [Subgraph in jobflow runs very slow](https://forum.cloverdx.com/t/subgraph-in-jobflow-runs-very-slow/3253)
**Author:** [@Bob\_Shuka](https://forum.cloverdx.com/u/Bob_Shuka)\ **Replies:** 1\ **Last updated:** [June 6, 2025, 12:36pm UTC](https://forum.cloverdx.com/t/subgraph-in-jobflow-runs-very-slow/3253 "2025-06-06T12:36:35Z")
I have a subgraph that, when I run it from within a graph take about 10 seconds to run. When I run the same subgraph from within a jobflow it takes about 7 minutes to run. Is there a setting somewhere that causes subgrap… --- ## [Producing excel file using Custom headers](https://forum.cloverdx.com/t/producing-excel-file-using-custom-headers/3247)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 2\ **Last updated:** [May 21, 2025, 9:44pm UTC](https://forum.cloverdx.com/t/producing-excel-file-using-custom-headers/3247 "2025-05-21T21:44:10Z")
Dear Forum members, I am creating a dataset for which i have headers within the dataset, I want to add additional two rows as additional header information on top of the dataset headers and produce an excel file. Examp… --- ## [Multiplying percentage values](https://forum.cloverdx.com/t/multiplying-percentage-values/3249)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [May 18, 2025, 8:33pm UTC](https://forum.cloverdx.com/t/multiplying-percentage-values/3249 "2025-05-18T20:33:21Z")
Dear Forum members, Do we have a percentage function? I calculate everything in decimal and then multiply it by 100 to get a percentage value but I wanted to keep it as a percentage while multiplying it to other number. … --- ## [Custom Logs](https://forum.cloverdx.com/t/custom-logs/3243)
**Author:** [@Crystal\_Choo](https://forum.cloverdx.com/u/Crystal_Choo)\ **Replies:** 1\ **Last updated:** [April 17, 2025, 1:09pm UTC](https://forum.cloverdx.com/t/custom-logs/3243 "2025-04-17T13:09:35Z")
Hi, I’m very new to CloverDX platform and I am currently playing around with the components to figure out how to conduct a complex transformation for large datasets. I want to create custom logs to the log each failure a… --- ## [HTTP Connector Java Bind Exemption CloverDX Designer](https://forum.cloverdx.com/t/http-connector-java-bind-exemption-cloverdx-designer/3241)
**Author:** [@Gabby\_Tuff](https://forum.cloverdx.com/u/Gabby_Tuff)\ **Replies:** 1\ **Last updated:** [April 16, 2025, 12:24pm UTC](https://forum.cloverdx.com/t/http-connector-java-bind-exemption-cloverdx-designer/3241 "2025-04-16T12:24:06Z")
CloverDX Designer When sending concurrent requests (via multiple HTTP Connectors) I am getting the following error for a subset of the requests: java.net.BindException: Address already in use: connect. My understanding… --- ## [SQL Query Parameters and SQL injection](https://forum.cloverdx.com/t/sql-query-parameters-and-sql-injection/3231)
**Author:** [@Mark\_Palermo](https://forum.cloverdx.com/u/Mark_Palermo)\ **Replies:** 1\ **Last updated:** [March 26, 2025, 7:49am UTC](https://forum.cloverdx.com/t/sql-query-parameters-and-sql-injection/3231 "2025-03-26T07:49:29Z")
I am attempting to create a re-usable subgraph for retrieving a database value based on a query parameter passed in. For scalability reasons, it is not reasonable to read the whole table and then filter in CloverDX. Th… --- ## [Serverless SQL (Oracle)](https://forum.cloverdx.com/t/serverless-sql-oracle/3222)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [March 19, 2025, 2:42pm UTC](https://forum.cloverdx.com/t/serverless-sql-oracle/3222 "2025-03-19T14:42:22Z")
Dear Forum Members, I have few questions, please do let me know whether this is possible using CloverDX: Can we use Serverless SQL within CloverDX Designer? How will the connections work for E2E ETL jobs? Serverless S… --- ## [Plugin for Custom CTL](https://forum.cloverdx.com/t/plugin-for-custom-ctl/1719)
**Author:** [@cloverdm](https://forum.cloverdx.com/u/cloverdm)\ **Replies:** 4\ **Last updated:** [September 24, 2024, 6:45am UTC](https://forum.cloverdx.com/t/plugin-for-custom-ctl/1719 "2024-09-24T06:45:38Z")
Hello Support , Thanks for the great Product , We made a java plugin for custom ctl function , currenly i deployed it in eclipse plugin folder , its works fine with internal jetty server, My question is when i use that … --- ## [Is xlsb format reable now?](https://forum.cloverdx.com/t/is-xlsb-format-reable-now/3201)
**Author:** [@Zhixin.Chen](https://forum.cloverdx.com/u/Zhixin.Chen)\ **Replies:** 1\ **Last updated:** [January 2, 2025, 3:55pm UTC](https://forum.cloverdx.com/t/is-xlsb-format-reable-now/3201 "2025-01-02T15:55:19Z")
how to read xlsb data? i saw a topic from 2020, ur replys are is considered as furture funktion, is that possible now? --- ## [Stored Procedure Returning Rows](https://forum.cloverdx.com/t/stored-procedure-returning-rows/3185)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 6\ **Last updated:** [November 30, 2024, 6:04pm UTC](https://forum.cloverdx.com/t/stored-procedure-returning-rows/3185 "2024-11-30T18:04:04Z")
Hi I’m trying to Execute a SQL sproc that has 3 arguments. The return data is 1000’s of rows, multiple columns. so the purpose of this sproc is to read data. Is this possible with the Clover designer as I’m having a few … --- ## [CloverDX connectivity to MS Teams/Share folders](https://forum.cloverdx.com/t/cloverdx-connectivity-to-ms-teams-share-folders/3193)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 3\ **Last updated:** [December 12, 2024, 9:43am UTC](https://forum.cloverdx.com/t/cloverdx-connectivity-to-ms-teams-share-folders/3193 "2024-12-12T09:43:40Z")
Dear Forum Members, We need to connect to MS Teams share folders in order to read the files and further to process, Is it possible to connect using CloverDX? Kind regards --- ## [S/sheet Writer Multiple Sheets](https://forum.cloverdx.com/t/s-sheet-writer-multiple-sheets/3188)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 6\ **Last updated:** [December 4, 2024, 6:46pm UTC](https://forum.cloverdx.com/t/s-sheet-writer-multiple-sheets/3188 "2024-12-04T18:46:57Z")
When I populate a sheet in Excel, I seem to run out of memory. In my example I have about 50k items. I’ve updated the component to do “streaming mode” which is quick and doesn’t error, but then it won’t allow me to prese… --- ## [SQL Query containing the output of a previous SQL query](https://forum.cloverdx.com/t/sql-query-containing-the-output-of-a-previous-sql-query/3184)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 2\ **Last updated:** [November 26, 2024, 9:39pm UTC](https://forum.cloverdx.com/t/sql-query-containing-the-output-of-a-previous-sql-query/3184 "2024-11-26T21:39:59Z")
Hi I’m using the DatabaseReader to read the following data from SQL: Field 1,2,3,4,5 I then send this to the input port of another DatabaseReader component but i’m trying to use the output from the previous component … --- ## [Can't connect to Azure SQL Server](https://forum.cloverdx.com/t/cant-connect-to-azure-sql-server/3181)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 2\ **Last updated:** [November 21, 2024, 10:04am UTC](https://forum.cloverdx.com/t/cant-connect-to-azure-sql-server/3181 "2024-11-21T10:04:40Z")
Hi we currently use other tools like PowerAutomate etc. to connect to to an Azure SQL Server. I’m now trying to use CloverDX Designer. I choose “New Connection” in the Connections outline pane and then click “MS SQL Ser… --- ## [Empty Source DB to target, but inspect data is showing 1 null record](https://forum.cloverdx.com/t/empty-source-db-to-target-but-inspect-data-is-showing-1-null-record/3178)
**Author:** [@MAKEFLO](https://forum.cloverdx.com/u/MAKEFLO)\ **Replies:** 1\ **Last updated:** [November 20, 2024, 1:20pm UTC](https://forum.cloverdx.com/t/empty-source-db-to-target-but-inspect-data-is-showing-1-null-record/3178 "2024-11-20T13:20:41Z")
I have a straightforward transformation. Customer table for example is empty in the backend (MS SQL Server) I just used select all in Customer table on DBExecute to DatabaseWriter, but in edge it showing 1 row of NULL va… --- ## [DatabaseWriter Insert INTO having error](https://forum.cloverdx.com/t/databasewriter-insert-into-having-error/3174)
**Author:** [@MAKEFLO](https://forum.cloverdx.com/u/MAKEFLO)\ **Replies:** 1\ **Last updated:** [November 13, 2024, 9:25pm UTC](https://forum.cloverdx.com/t/databasewriter-insert-into-having-error/3174 "2024-11-13T21:25:48Z")
New to CloverDX. I am having an error in DatabaseWriter transformation when doing insert into I have DBExecute with query selecting from transactions table, using transactions metadata for edge. in DatabaseWrite I have … --- ## [Can't get start date and end date value](https://forum.cloverdx.com/t/cant-get-start-date-and-end-date-value/3172)
**Author:** [@MAKEFLO](https://forum.cloverdx.com/u/MAKEFLO)\ **Replies:** 2\ **Last updated:** [November 13, 2024, 12:09am UTC](https://forum.cloverdx.com/t/cant-get-start-date-and-end-date-value/3172 "2024-11-13T00:09:51Z")
New in CloverDX. I created a Database reader connected to trash just to test if i can use variable date variables, my query below select ‘${start\_date}’ as start\_date, ‘${end\_date}’ as end\_date I’m using metadata name … --- ## [Graphs logs retention period](https://forum.cloverdx.com/t/graphs-logs-retention-period/2172)
**Author:** [@Lubos\_Imriska](https://forum.cloverdx.com/u/Lubos_Imriska)\ **Replies:** 2\ **Last updated:** [October 22, 2024, 2:07pm UTC](https://forum.cloverdx.com/t/graphs-logs-retention-period/2172 "2024-10-22T14:07:15Z")
its possible to change/edit the retention period for the graph logs in \[your\_tomcat\_directory\]/temp/cloverlogs/graph ? --- ## [Locale - European or UK number/date formats handling](https://forum.cloverdx.com/t/locale-european-or-uk-number-date-formats-handling/2173)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [October 31, 2024, 11:05am UTC](https://forum.cloverdx.com/t/locale-european-or-uk-number-date-formats-handling/2173 "2024-10-31T11:05:43Z")
Dear Support, I wanted to use the conversion function to produce output in UK number formats, My input file contains European and UK format number system. With the help of CloverDX support (Thank you) I have managed to… --- ## [Transposing rows into columns with column headers & column values](https://forum.cloverdx.com/t/transposing-rows-into-columns-with-column-headers-column-values/2171)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [July 29, 2024, 12:00am UTC](https://forum.cloverdx.com/t/transposing-rows-into-columns-with-column-headers-column-values/2171 "2024-07-29T00:00:00Z")
Dear Support, We have a data as below: and we wanted to see the output as below: I have tried using MetaPivot, it did transpose the rows into columns but I am unable to group it by “Code”, I wanted to group ever… [Next page](https://forum.cloverdx.com/c/cloverdx/5.md?page=1)