# Toad Data Point & Toad Intelligence Central **URL:** https://forums.toadworld.com/c/toad-data-point/35.md [Latest](https://forums.toadworld.com/latest.md) · [Categories](https://forums.toadworld.com/categories.md) --- ## [Toad Workbook: Support Snapshot and Existing Table Options in Save to Local Storage](https://forums.toadworld.com/t/toad-workbook-support-snapshot-and-existing-table-options-in-save-to-local-storage/61877)
**Author:** [@ivica.nikolic](https://forums.toadworld.com/u/ivica.nikolic)\ **Replies:** 0\ **Last updated:** [September 30, 2026, 7:39am UTC](https://forums.toadworld.com/t/toad-workbook-support-snapshot-and-existing-table-options-in-save-to-local-storage/61877 "2026-09-30T07:39:15Z")
Currently, the Save to Local Storage step in Toad Workbook only supports "A single new table", while "A snapshot" and "A single existing table" are shown but unavailable. Enhancement request: Enhance the Save to Local … --- ## [Workbook - Unable to Output Results to Existing Local Storage Table](https://forums.toadworld.com/t/workbook-unable-to-output-results-to-existing-local-storage-table/61872)
**Author:** [@InfoMan](https://forums.toadworld.com/u/InfoMan)\ **Replies:** 2\ **Last updated:** [September 29, 2026, 3:14pm UTC](https://forums.toadworld.com/t/workbook-unable-to-output-results-to-existing-local-storage-table/61872 "2026-09-29T15:14:16Z")
Goal: Use Workbook to Run a query, Save the results to an existing table in Local Storage Results would append the table (not truncate, not drop & create if exists). Issue: When I create the Output step to save to Lo… --- ## [Sorting Pivot Grid on a Particular Column Within the Data?](https://forums.toadworld.com/t/sorting-pivot-grid-on-a-particular-column-within-the-data/61850)
**Author:** [@InfoMan](https://forums.toadworld.com/u/InfoMan)\ **Replies:** 2\ **Last updated:** [September 29, 2026, 3:10pm UTC](https://forums.toadworld.com/t/sorting-pivot-grid-on-a-particular-column-within-the-data/61850 "2026-09-29T15:10:59Z")
I have a pivot grid with rows of data for each U.S. State and the data area is counting customer orders. The count is sub-divided into columns for each week (YYYYWW format). Can the grid be configured to sort the rows … --- ## [Toad DataPoint - TDS Access to MS Dataverse](https://forums.toadworld.com/t/toad-datapoint-tds-access-to-ms-dataverse/61865)
**Author:** [@tbynum](https://forums.toadworld.com/u/tbynum)\ **Replies:** 1\ **Last updated:** [September 25, 2026, 7:55am UTC](https://forums.toadworld.com/t/toad-datapoint-tds-access-to-ms-dataverse/61865 "2026-09-25T07:55:18Z")
Hello. I'm trying to configure a connection for DataPoint to be able to query MS Dataverse using the same "TDS" setup that SSMS uses. I got the connection to work fine in SSMS, but I cannot get the connection to work i… --- ## [Position Data Area Totals After Each Data Value Instead of at the End?](https://forums.toadworld.com/t/position-data-area-totals-after-each-data-value-instead-of-at-the-end/61849)
**Author:** [@InfoMan](https://forums.toadworld.com/u/InfoMan)\ **Replies:** 2\ **Last updated:** [September 17, 2026, 2:52pm UTC](https://forums.toadworld.com/t/position-data-area-totals-after-each-data-value-instead-of-at-the-end/61849 "2026-09-17T14:52:54Z")
I have a pivot grid with two fields in the Data Area (summing quantity and dollar value) and each are sub-divided into 4 categories of product. The totals for each calculation are being placed at the far right-end of ea… --- ## [Object Explorer Keeps Switching to Treelist](https://forums.toadworld.com/t/object-explorer-keeps-switching-to-treelist/61821)
**Author:** [@InfoMan](https://forums.toadworld.com/u/InfoMan)\ **Replies:** 6\ **Last updated:** [August 28, 2026, 3:03pm UTC](https://forums.toadworld.com/t/object-explorer-keeps-switching-to-treelist/61821 "2026-08-28T15:03:00Z")
Recently upgraded to 2026 R1. The Object Explorer keeps switching to Treelist view. Oracle likes any of the other views. With Treelist it doesn't display anything. I keep setting it to Tabbed, but on the next day...ba… --- ## [Filtering in Result Sets](https://forums.toadworld.com/t/filtering-in-result-sets/46735)
**Author:** [@InfoMan](https://forums.toadworld.com/u/InfoMan)\ **Replies:** 4\ **Last updated:** [August 19, 2026, 5:57pm UTC](https://forums.toadworld.com/t/filtering-in-result-sets/46735 "2026-08-19T17:57:56Z")
Version 5.0.4.45 (32 bit) Ran a small query, then filtered the results by clicking on the filter icon for the desired column. The data type of the TIME\_BOX\_SHIPPED column is NUMBER(6). I set the filter to be greater t… --- ## [Toad Datapoint 6.4 hangs up on starting](https://forums.toadworld.com/t/toad-datapoint-6-4-hangs-up-on-starting/60790)
**Author:** [@asprasad](https://forums.toadworld.com/u/asprasad)\ **Replies:** 7\ **Last updated:** [August 18, 2026, 2:32pm UTC](https://forums.toadworld.com/t/toad-datapoint-6-4-hangs-up-on-starting/60790 "2026-08-18T14:32:24Z")
Toad datapoint gives a "Creating application window- 50%" and persists on the screen. It is not a memory issue --- ## [Layout Order for Field Settings in Query Builder Diagram Tab](https://forums.toadworld.com/t/layout-order-for-field-settings-in-query-builder-diagram-tab/61769)
**Author:** [@InfoMan](https://forums.toadworld.com/u/InfoMan)\ **Replies:** 3\ **Last updated:** [August 4, 2026, 6:59am UTC](https://forums.toadworld.com/t/layout-order-for-field-settings-in-query-builder-diagram-tab/61769 "2026-08-04T06:59:11Z")
I just upgraded from 6.x to 2026 R1. I noticed that the order/layout of the field settings at the bottom of the Query Builder's Diagram tab have changed. After years of muscle memory expecting the WHERE to be the third… --- ## [Be able to rename subquery's used in the query builder](https://forums.toadworld.com/t/be-able-to-rename-subquerys-used-in-the-query-builder/54646)
**Author:** [@AJD](https://forums.toadworld.com/u/AJD)\ **Replies:** 1\ **Last updated:** [July 29, 2026, 4:12pm UTC](https://forums.toadworld.com/t/be-able-to-rename-subquerys-used-in-the-query-builder/54646 "2026-07-29T16:12:22Z")
Be able to rename subquery's used in the query builder. At this moment the name is automatically created without an option to change the name. Query --\> Subquery --\> Subquery\_1 --\> Subquery\_2 --\> Subquery\_3 --- ## [Bind variables disappearing when new ones are added](https://forums.toadworld.com/t/bind-variables-disappearing-when-new-ones-are-added/61758)
**Author:** [@charles.zufferey](https://forums.toadworld.com/u/charles.zufferey)\ **Replies:** 3\ **Last updated:** [July 27, 2026, 9:58am UTC](https://forums.toadworld.com/t/bind-variables-disappearing-when-new-ones-are-added/61758 "2026-07-27T09:58:32Z")
Toad Data Point 2026 R1 When creating bind variables (permanent variables) via the projet explorer (x)= , it is possible to add many variables consecutively and they are being registered. However if, later on, we add ne… --- ## [Enable True Parallel Execution of Automation Scripts in Toad Data Point](https://forums.toadworld.com/t/enable-true-parallel-execution-of-automation-scripts-in-toad-data-point/61737)
**Author:** [@AJD](https://forums.toadworld.com/u/AJD)\ **Replies:** 0\ **Last updated:** [July 3, 2026, 6:23pm UTC](https://forums.toadworld.com/t/enable-true-parallel-execution-of-automation-scripts-in-toad-data-point/61737 "2026-07-03T18:23:22Z")
Request the ability for Toad Data Point Automation to execute multiple child automation scripts concurrently (true parallel execution) instead of executing them sequentially when using the Parallel activity. Although Au… --- ## [.tas file how to encode as utf-8 instead of utf-16](https://forums.toadworld.com/t/tas-file-how-to-encode-as-utf-8-instead-of-utf-16/61714)
**Author:** [@jchall](https://forums.toadworld.com/u/jchall)\ **Replies:** 0\ **Last updated:** [June 10, 2026, 3:12pm UTC](https://forums.toadworld.com/t/tas-file-how-to-encode-as-utf-8-instead-of-utf-16/61714 "2026-06-10T15:12:03Z")
Our Toad Data Point automation scripts automatically encodes using utf-16, however, we would like to use utf-8. We don't see an option for this when saving these files. We tried opening in a text and encode as utf-8 but … --- ## [Export Wizard Excel Document Fail](https://forums.toadworld.com/t/export-wizard-excel-document-fail/61706)
**Author:** [@ms.melissa.cusey](https://forums.toadworld.com/u/ms.melissa.cusey)\ **Replies:** 1\ **Last updated:** [June 8, 2026, 10:20am UTC](https://forums.toadworld.com/t/export-wizard-excel-document-fail/61706 "2026-06-08T10:20:34Z")
Long story short, in TOAD Data Point 4.3 using the Export Wizard query method went through the process and I received the Excel file, however there is a problem with the document where some content. When I hit yes to try… --- ## [How to reduce logging in Toad Data Point?](https://forums.toadworld.com/t/how-to-reduce-logging-in-toad-data-point/61704)
**Author:** [@pihla.patosalmi](https://forums.toadworld.com/u/pihla.patosalmi)\ **Replies:** 3\ **Last updated:** [June 5, 2026, 8:28am UTC](https://forums.toadworld.com/t/how-to-reduce-logging-in-toad-data-point/61704 "2026-06-05T08:28:08Z")
My Toad64.log file (under AppData\\Local\\Quest Software) grows in just couple of days to the size of nearly 1G. How can I reduce or remove the logging? --- ## [Excel/CSV Column with a mix of Integers and strings](https://forums.toadworld.com/t/excel-csv-column-with-a-mix-of-integers-and-strings/61662)
**Author:** [@16deanm](https://forums.toadworld.com/u/16deanm)\ **Replies:** 9\ **Last updated:** [April 30, 2026, 2:34pm UTC](https://forums.toadworld.com/t/excel-csv-column-with-a-mix-of-integers-and-strings/61662 "2026-04-30T14:34:33Z")
I have an Excel file with a column that contains a mix of integers and strings , majority of the rows are just a list of integers(example below). When I import the file into Toad Data Point, it automatically converts th… --- ## [Display Schema for each table in the object explorer and Display the name of the table in the result set grid](https://forums.toadworld.com/t/display-schema-for-each-table-in-the-object-explorer-and-display-the-name-of-the-table-in-the-result-set-grid/61661)
**Author:** [@AJD](https://forums.toadworld.com/u/AJD)\ **Replies:** 0\ **Last updated:** [April 28, 2026, 9:45pm UTC](https://forums.toadworld.com/t/display-schema-for-each-table-in-the-object-explorer-and-display-the-name-of-the-table-in-the-result-set-grid/61661 "2026-04-28T21:45:52Z")
1 .Display the schema name for each table in the object explorer (when using snowflake) 2. Display the name of the table in the result set grid after executing a query --- ## [Cleanse and Transform with leading zeroes](https://forums.toadworld.com/t/cleanse-and-transform-with-leading-zeroes/61659)
**Author:** [@16deanm](https://forums.toadworld.com/u/16deanm)\ **Replies:** 3\ **Last updated:** [April 28, 2026, 2:59pm UTC](https://forums.toadworld.com/t/cleanse-and-transform-with-leading-zeroes/61659 "2026-04-28T14:59:08Z")
So I have a CSV file that has a column of integers. I convert it into a string now I dont know how I can take that and add leading zeros base don the length of the current value. So for example if I have the number 5 \> … --- ## [Median Function not Available in Pivots?](https://forums.toadworld.com/t/median-function-not-available-in-pivots/61637)
**Author:** [@InfoMan](https://forums.toadworld.com/u/InfoMan)\ **Replies:** 2\ **Last updated:** [April 28, 2026, 1:31pm UTC](https://forums.toadworld.com/t/median-function-not-available-in-pivots/61637 "2026-04-28T13:31:55Z")
I just noticed that the Median function is available in the Aggregate dropdown in query builder and in Transform & Cleanse, but it is not available in pivots. Anyone have a way to handle this in pivots? --- ## [Docked Menu Bar](https://forums.toadworld.com/t/docked-menu-bar/61654)
**Author:** [@AmandaH10](https://forums.toadworld.com/u/AmandaH10)\ **Replies:** 1\ **Last updated:** [April 28, 2026, 8:37am UTC](https://forums.toadworld.com/t/docked-menu-bar/61654 "2026-04-28T08:37:18Z")
I accidentally moved part of the menu bar above the SQL editor window and am now unable to remove it. I've attempted the usual troubleshooting steps, such as exploring customization options and reviewing various categori… --- ## [Toad Data Point Export to Excel Error - The exported data cannot be saved when the file is in use](https://forums.toadworld.com/t/toad-data-point-export-to-excel-error-the-exported-data-cannot-be-saved-when-the-file-is-in-use/58385)
**Author:** [@vba\_CoderAusTx](https://forums.toadworld.com/u/vba_CoderAusTx)\ **Replies:** 6\ **Last updated:** [April 24, 2026, 12:43pm UTC](https://forums.toadworld.com/t/toad-data-point-export-to-excel-error-the-exported-data-cannot-be-saved-when-the-file-is-in-use/58385 "2026-04-24T12:43:25Z")
We have Office 365 and Toad v5.6. When my Toad automation job runs, whether it's in the "Administrator" console as a scheduled job, or if I am running it within the designer, when the data is exporting to Excel, I recei… --- ## [Re-arrange Steps in Transform Cleanse?](https://forums.toadworld.com/t/re-arrange-steps-in-transform-cleanse/61613)
**Author:** [@eric.hoover](https://forums.toadworld.com/u/eric.hoover)\ **Replies:** 1\ **Last updated:** [March 18, 2026, 6:09am UTC](https://forums.toadworld.com/t/re-arrange-steps-in-transform-cleanse/61613 "2026-03-18T06:09:08Z")
I am using Toad Workbook - I have created several ‘steps’ in my Transform and Cleanse and would like to re-arrange the order, but it doesn’t seem possible. Is there a way to do this? Thanks --- ## [TIC Daily Digest Email Showing Incorrect HTTP Link After HTTPS Migration](https://forums.toadworld.com/t/tic-daily-digest-email-showing-incorrect-http-link-after-https-migration/61604)
**Author:** [@gaby.saavedra](https://forums.toadworld.com/u/gaby.saavedra)\ **Replies:** 1\ **Last updated:** [March 12, 2026, 6:55pm UTC](https://forums.toadworld.com/t/tic-daily-digest-email-showing-incorrect-http-link-after-https-migration/61604 "2026-03-12T18:55:46Z")
After migrating Toad Intelligence Central (TIC) from HTTP to HTTPS, the customer reports that the Admin Daily Digest email is still displaying an HTTP link within the digest content. While TIC itself is fully running und… --- ## [Toad Data Studio 2026 R1 is now GA!](https://forums.toadworld.com/t/toad-data-studio-2026-r1-is-now-ga/61598)
**Author:** [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\ **Replies:** 0\ **Last updated:** [March 10, 2026, 10:59pm UTC](https://forums.toadworld.com/t/toad-data-studio-2026-r1-is-now-ga/61598 "2026-03-10T22:59:27Z")
We are pleased to announce Toad Data Studio 2026 R1 is now available, expanding licensing capabilities to provide greater flexibility for those wanting to use AI features. AI Licensing Flexibility - Users can now add … --- ## [Exporting Query and Results Only](https://forums.toadworld.com/t/exporting-query-and-results-only/61563)
**Author:** [@scott.le](https://forums.toadworld.com/u/scott.le)\ **Replies:** 1\ **Last updated:** [March 6, 2026, 7:45am UTC](https://forums.toadworld.com/t/exporting-query-and-results-only/61563 "2026-03-06T07:45:23Z")
Hello, I tried searching through the deep forum conversations over the years (and noticed as I was making this post there was a live search for topics that related to this) but I just want to export the raw data from my… --- ## [Deploy TDP for Mac with license and connections](https://forums.toadworld.com/t/deploy-tdp-for-mac-with-license-and-connections/61591)
**Author:** [@bpbecker](https://forums.toadworld.com/u/bpbecker)\ **Replies:** 0\ **Last updated:** [March 6, 2026, 3:29am UTC](https://forums.toadworld.com/t/deploy-tdp-for-mac-with-license-and-connections/61591 "2026-03-06T03:29:15Z")
I’m trying to get TDP deployed via the Iru MDM, and have discovered no documentation for the Mac installer. I can deploy a license for the current user, but not for all users. I have yet to find a way to automate confi… --- ## [JDBC](https://forums.toadworld.com/t/jdbc/6567)
**Author:** [@mdugan\_703](https://forums.toadworld.com/u/mdugan_703)\ **Replies:** 8\ **Last updated:** [February 27, 2026, 10:06am UTC](https://forums.toadworld.com/t/jdbc/6567 "2026-02-27T10:06:54Z")
Can TDA make a connection to DB2 using JDBC instead of ODBC? Thanks, Mike --- ## [Sort fields in Code Completion](https://forums.toadworld.com/t/sort-fields-in-code-completion/61520)
**Author:** [@eric.hoover](https://forums.toadworld.com/u/eric.hoover)\ **Replies:** 0\ **Last updated:** [January 16, 2026, 9:24pm UTC](https://forums.toadworld.com/t/sort-fields-in-code-completion/61520 "2026-01-16T21:24:24Z")
Add functionality to Sort data fields alphabetically in the Code Completion pop-up instead of the default order of how they appear in the table: --- ## [Cannot change Editor Background](https://forums.toadworld.com/t/cannot-change-editor-background/61492)
**Author:** [@Dready1906](https://forums.toadworld.com/u/Dready1906)\ **Replies:** 3\ **Last updated:** [January 13, 2026, 9:26am UTC](https://forums.toadworld.com/t/cannot-change-editor-background/61492 "2026-01-13T09:26:44Z")
I like a darker screen. Having downloaded ver.25.2, all settings are EXACTLY the same as my previous 6.4 installation, except for the Background color here. I want it to be black (0,0,0), but every time I change it it … --- ## [SFTP Connection](https://forums.toadworld.com/t/sftp-connection/51911)
**Author:** [@steve.bynum2013](https://forums.toadworld.com/u/steve.bynum2013)\ **Replies:** 6\ **Last updated:** [January 12, 2026, 3:14pm UTC](https://forums.toadworld.com/t/sftp-connection/51911 "2026-01-12T15:14:32Z")
I am setting up an sftp and I get the following error when I test the connection: The negotiation of key exchange method has failed When using WinScp, I have no problem connecting. Does anyone know what the problem co… [Next page](https://forums.toadworld.com/c/toad-data-point/35.md?page=1)