# Toad Data Modeler **URL:** https://forums.toadworld.com/c/toad-data-modeler/15.md [Latest](https://forums.toadworld.com/latest.md) · [Categories](https://forums.toadworld.com/categories.md) --- ## [Importing Column-Level Comments from Excel into TDM](https://forums.toadworld.com/t/importing-column-level-comments-from-excel-into-tdm/61805)
**Author:** [@rmanivannan](https://forums.toadworld.com/u/rmanivannan)\ **Replies:** 4\ **Last updated:** [September 1, 2026, 2:13pm UTC](https://forums.toadworld.com/t/importing-column-level-comments-from-excel-into-tdm/61805 "2026-09-01T14:13:01Z")
Hi, I’m using Toad Data Modeler (TDM) v7.3. In our current data model, most tables do not have descriptions/comments for individual attributes (columns). We are now planning to add comments for all attributes. Instead … --- ## [Unable to Generate Model Comparison Report in TDM 7.3 After Comparing Two Data Models](https://forums.toadworld.com/t/unable-to-generate-model-comparison-report-in-tdm-7-3-after-comparing-two-data-models/61768)
**Author:** [@rmanivannan](https://forums.toadworld.com/u/rmanivannan)\ **Replies:** 3\ **Last updated:** [August 7, 2026, 8:02pm UTC](https://forums.toadworld.com/t/unable-to-generate-model-comparison-report-in-tdm-7-3-after-comparing-two-data-models/61768 "2026-08-07T20:02:03Z")
Hi, I'm using TDM version 7.3 and trying to compare two data models to generate a report showing the differences. After opening both models in TDM, I followed these steps: Model → Compare and Generate Report Selected… --- ## [Access violation on connecting to Postgres database](https://forums.toadworld.com/t/access-violation-on-connecting-to-postgres-database/61676)
**Author:** [@kai.quale](https://forums.toadworld.com/u/kai.quale)\ **Replies:** 4\ **Last updated:** [August 7, 2026, 10:53am UTC](https://forums.toadworld.com/t/access-violation-on-connecting-to-postgres-database/61676 "2026-08-07T10:53:22Z")
I'm trying to connect to a Postgres database, but I get the following error: "Access violation at address 00000000004148D5 in module 'TDM.exe'. Read of address 0000000000000018". I'm using TDM 8.0 with SSL Mode = Prefe… --- ## [Connections disappeared](https://forums.toadworld.com/t/connections-disappeared/61486)
**Author:** [@dsams](https://forums.toadworld.com/u/dsams)\ **Replies:** 0\ **Last updated:** [December 26, 2025, 4:39pm UTC](https://forums.toadworld.com/t/connections-disappeared/61486 "2025-12-26T16:39:27Z")
I recently received a new laptop and re-installed Toad for Data Modeler 7.3. I didnt open any models at that time. Now I have a need to open models and noticed all connections disappeared. I also installed Toad for Data … --- ## [Connections disappeared](https://forums.toadworld.com/t/connections-disappeared/61485)
**Author:** [@dsams](https://forums.toadworld.com/u/dsams)\ **Replies:** 1\ **Last updated:** [December 26, 2025, 4:38pm UTC](https://forums.toadworld.com/t/connections-disappeared/61485 "2025-12-26T16:38:54Z")
I recently received a new laptop and re-installed Toad for Data Modeler 7.3. I didnt open any models at that time. Now I have a need to open models and noticed all connections disappeared. I also installed Toad for Dat… --- ## [Connection to Azure DB with Entra MFA](https://forums.toadworld.com/t/connection-to-azure-db-with-entra-mfa/61465)
**Author:** [@mtechera](https://forums.toadworld.com/u/mtechera)\ **Replies:** 2\ **Last updated:** [December 16, 2025, 4:48am UTC](https://forums.toadworld.com/t/connection-to-azure-db-with-entra-mfa/61465 "2025-12-16T04:48:56Z")
I am trying to connect to an Azure DB using my Entra Login with MFA in TOAD Data Modeler. I can connect with SQL Server Management Studio as well as Visual COde without any problems from the same machine. Is this not s… --- ## [LDAP connectivity support for Toad Data Modeler](https://forums.toadworld.com/t/ldap-connectivity-support-for-toad-data-modeler/61446)
**Author:** [@armando.reyes](https://forums.toadworld.com/u/armando.reyes)\ **Replies:** 1\ **Last updated:** [December 2, 2025, 5:02pm UTC](https://forums.toadworld.com/t/ldap-connectivity-support-for-toad-data-modeler/61446 "2025-12-02T17:02:28Z")
Toad Data Modeler currently doesn’t connect to an Oracle database using only LDAP, although there is an Oracle Client and other applications can connect freely using LDAP only and not tnsname.ora file, Toad Data Modeler … --- ## [Is TDM available for sale?](https://forums.toadworld.com/t/is-tdm-available-for-sale/61028)
**Author:** [@bog](https://forums.toadworld.com/u/bog)\ **Replies:** 1\ **Last updated:** [September 26, 2025, 8:05am UTC](https://forums.toadworld.com/t/is-tdm-available-for-sale/61028 "2025-09-26T08:05:15Z")
If yes, where? It used to be available online to "rent" for a year but now I don't see it. Thanks --- ## [Support for PostgreSQL Version 15, 16, 17](https://forums.toadworld.com/t/support-for-postgresql-version-15-16-17/61193)
**Author:** [@nestor.castro](https://forums.toadworld.com/u/nestor.castro)\ **Replies:** 1\ **Last updated:** [July 25, 2025, 7:54pm UTC](https://forums.toadworld.com/t/support-for-postgresql-version-15-16-17/61193 "2025-07-25T19:54:51Z")
Hello TDM Team, could you consider the feasibility to add support for PostgreSQL 15,16,17 Thank you --- ## [Connection to Oracle Database with proxy user does not work](https://forums.toadworld.com/t/connection-to-oracle-database-with-proxy-user-does-not-work/47230)
**Author:** [@johannes.wandt](https://forums.toadworld.com/u/johannes.wandt)\ **Replies:** 6\ **Last updated:** [July 1, 2025, 10:44pm UTC](https://forums.toadworld.com/t/connection-to-oracle-database-with-proxy-user-does-not-work/47230 "2025-07-01T22:44:28Z")
Hi, We are using proxy accounts to login to our Oracle database. In Oracle Developer it works like this: login: mypersonaluser\[stg\] passowrd: pw of mypersonaluser So I am logged in as user stg and have all his righ… --- ## [Custom Macro to generate Audit Tables is not working](https://forums.toadworld.com/t/custom-macro-to-generate-audit-tables-is-not-working/61126)
**Author:** [@vbuda](https://forums.toadworld.com/u/vbuda)\ **Replies:** 0\ **Last updated:** [June 26, 2025, 12:35pm UTC](https://forums.toadworld.com/t/custom-macro-to-generate-audit-tables-is-not-working/61126 "2025-06-26T12:35:26Z")
I Created a Custom Macro on Toad Data Modeler, Version 8.0 This macro is suppose to generate Audit tables for all the entities I have in the Model, when I run the macro it does nothing. Any help on this will be greatly … --- ## [Toad Data Modeler connect to Databricks](https://forums.toadworld.com/t/toad-data-modeler-connect-to-databricks/60938)
**Author:** [@mmarcavage](https://forums.toadworld.com/u/mmarcavage)\ **Replies:** 1\ **Last updated:** [June 6, 2025, 5:02pm UTC](https://forums.toadworld.com/t/toad-data-modeler-connect-to-databricks/60938 "2025-06-06T17:02:11Z")
Is there a way to connect Toad Data Modeler 7.3 to Databricks? I cannot find anything that talks about this. --- ## [Toad Data Modeler 8.0 is now GA!](https://forums.toadworld.com/t/toad-data-modeler-8-0-is-now-ga/60763)
**Author:** [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\ **Replies:** 0\ **Last updated:** [March 24, 2025, 8:43pm UTC](https://forums.toadworld.com/t/toad-data-modeler-8-0-is-now-ga/60763 "2025-03-24T20:43:18Z")
We are pleased to announce the GA of Toad Data Modeler 8.0! For all existing customers, Toad Data Modeler 8.0 contains new fixes and platform support. New Database Support: Oracle 21c Microsoft SQL Server 2022 New O… --- ## [Generate change script error](https://forums.toadworld.com/t/generate-change-script-error/60539)
**Author:** [@lgerard](https://forums.toadworld.com/u/lgerard)\ **Replies:** 2\ **Last updated:** [February 10, 2025, 10:37am UTC](https://forums.toadworld.com/t/generate-change-script-error/60539 "2025-02-10T10:37:53Z")
I am trying to generate a change script between two versions of my scheme. (PostgreSQL) During the process Toad encouters a lot of errors like this : I dont know what to do to fix that. Any advise, idea ? --- ## [Connect toad data modeler with cert to oracle database](https://forums.toadworld.com/t/connect-toad-data-modeler-with-cert-to-oracle-database/60416)
**Author:** [@Dave\_H2](https://forums.toadworld.com/u/Dave_H2)\ **Replies:** 3\ **Last updated:** [January 13, 2025, 4:29pm UTC](https://forums.toadworld.com/t/connect-toad-data-modeler-with-cert-to-oracle-database/60416 "2025-01-13T16:29:43Z")
Hello, I am attempting to connect toad data modeler to an oracle database. Toad data modeler is not detecting the oracle home and even when I attempt to use a Toad for Oracle connection if fails with end of communicati… --- ## [Javascript runtime error - Unable to reverse engineer](https://forums.toadworld.com/t/javascript-runtime-error-unable-to-reverse-engineer/60177)
**Author:** [@rmanivannan](https://forums.toadworld.com/u/rmanivannan)\ **Replies:** 6\ **Last updated:** [December 10, 2024, 8:01pm UTC](https://forums.toadworld.com/t/javascript-runtime-error-unable-to-reverse-engineer/60177 "2024-12-10T20:01:22Z")
Hi All, I'm using TDM 7.3, I was able to reverse engineer existing tables earlier. However today if I click reverse engineering-connections, I'm getting below error message. Could you please help me to fix this. Datab… --- ## [Options to export data model](https://forums.toadworld.com/t/options-to-export-data-model/60250)
**Author:** [@rmanivannan](https://forums.toadworld.com/u/rmanivannan)\ **Replies:** 1\ **Last updated:** [November 27, 2024, 5:27pm UTC](https://forums.toadworld.com/t/options-to-export-data-model/60250 "2024-11-27T17:27:23Z")
I'm using TDM v7.3, is it possible to export data model as an “.erx” or “.xml” file? Please advise. Thanks ! Rajesh --- ## [Toad Data Modeler - Error while using "Export to excel" feature](https://forums.toadworld.com/t/toad-data-modeler-error-while-using-export-to-excel-feature/59988)
**Author:** [@rmanivannan](https://forums.toadworld.com/u/rmanivannan)\ **Replies:** 0\ **Last updated:** [September 24, 2024, 4:20pm UTC](https://forums.toadworld.com/t/toad-data-modeler-error-while-using-export-to-excel-feature/59988 "2024-09-24T16:20:58Z")
In Toad Data Modeler 7.3 if I try to export all tables and attributes using "Export to excel" from TDM menu, I'm getting below error. Can anyone please assist me to resolve this? Thanks ! Regards, Rajesh --- ## [How to format Data Type in Toad Data Modeler export file](https://forums.toadworld.com/t/how-to-format-data-type-in-toad-data-modeler-export-file/59892)
**Author:** [@rmanivannan](https://forums.toadworld.com/u/rmanivannan)\ **Replies:** 2\ **Last updated:** [September 5, 2024, 12:55pm UTC](https://forums.toadworld.com/t/how-to-format-data-type-in-toad-data-modeler-export-file/59892 "2024-09-05T12:55:28Z")
Hi All, In the Toad Modeler’s export.xlsx file under the Attributes tab the Data Type column is represented with 2 parameters like “Varchar2(%p1 %p2)” where the values for p1 and p2 are broken out into separate columns.… --- ## [Encounter internal error when do reverse engineer from a postgres 9.5 database](https://forums.toadworld.com/t/encounter-internal-error-when-do-reverse-engineer-from-a-postgres-9-5-database/59900)
**Author:** [@agao0001](https://forums.toadworld.com/u/agao0001)\ **Replies:** 0\ **Last updated:** [September 4, 2024, 1:51pm UTC](https://forums.toadworld.com/t/encounter-internal-error-when-do-reverse-engineer-from-a-postgres-9-5-database/59900 "2024-09-04T13:51:09Z")
Toad data modeler version: 7.3 got error : Source : Toad Data Modeler: - internal error Script : REDataMigrationDBPG95 Description: column r.rolbypassrls does notexist Row: 2410 Column: 3 Callstack: "REDataMigrat… --- ## [Problem reverse engineering MS SQL 2019 optimize\_for\_sequential\_key](https://forums.toadworld.com/t/problem-reverse-engineering-ms-sql-2019-optimize-for-sequential-key/59667)
**Author:** [@renzo.mischianti](https://forums.toadworld.com/u/renzo.mischianti)\ **Replies:** 2\ **Last updated:** [July 10, 2024, 5:02pm UTC](https://forums.toadworld.com/t/problem-reverse-engineering-ms-sql-2019-optimize-for-sequential-key/59667 "2024-07-10T17:02:56Z")
Hi, I have a problem on reverse engineerign in MS SQL 2019 with in memory table. I think there isn't the management of parameter optimize\_for\_sequential\_key. Thanks --- ## [Access Violation Error - TDM 7.3](https://forums.toadworld.com/t/access-violation-error-tdm-7-3/59132)
**Author:** [@rmanivannan](https://forums.toadworld.com/u/rmanivannan)\ **Replies:** 0\ **Last updated:** [March 19, 2024, 4:59pm UTC](https://forums.toadworld.com/t/access-violation-error-tdm-7-3/59132 "2024-03-19T16:59:53Z")
Hello, I have installed TDM 7.3 and in the model database platform selected as MySQL 5.5 When I tried to modify the existing data model, I'm getting access violation error. Can anyone please let me know how to fix this… --- ## [Adding Attributes to all entities in LDM](https://forums.toadworld.com/t/adding-attributes-to-all-entities-in-ldm/2719)
**Author:** [@balasake](https://forums.toadworld.com/u/balasake)\ **Replies:** 3\ **Last updated:** [March 6, 2024, 10:48am UTC](https://forums.toadworld.com/t/adding-attributes-to-all-entities-in-ldm/2719 "2024-03-06T10:48:01Z")
Hi, I am using Toad Data Modeler 3.5. I want to add some attributes to all entities in logical data model Please help me how to do this Thanks & Regards Bala Sake --- ## [Transformation in TOAD](https://forums.toadworld.com/t/transformation-in-toad/59008)
**Author:** [@ivana.kozakova](https://forums.toadworld.com/u/ivana.kozakova)\ **Replies:** 3\ **Last updated:** [February 27, 2024, 10:36pm UTC](https://forums.toadworld.com/t/transformation-in-toad/59008 "2024-02-27T22:36:24Z")
Hello all, please, how to store a mapping of table in TOAD DM, respectively where transaformation is stored in this tool? Please, can someone give us some advice? Many thanks for your time, Ivana We use the TOAD Dat… --- ## [How to import a powerdesigner data model file(.pdm) into TDM 6.1](https://forums.toadworld.com/t/how-to-import-a-powerdesigner-data-model-file-pdm-into-tdm-6-1/57128)
**Author:** [@NotFound20](https://forums.toadworld.com/u/NotFound20)\ **Replies:** 2\ **Last updated:** [February 27, 2024, 10:45am UTC](https://forums.toadworld.com/t/how-to-import-a-powerdesigner-data-model-file-pdm-into-tdm-6-1/57128 "2024-02-27T10:45:55Z")
I want to import power designer data model file into toad data modeler 6.1. Is there any way to perform the import ? --- ## [Change Script Always Includes Add Table for Two Tables](https://forums.toadworld.com/t/change-script-always-includes-add-table-for-two-tables/58879)
**Author:** [@brinehart](https://forums.toadworld.com/u/brinehart)\ **Replies:** 0\ **Last updated:** [February 1, 2024, 11:27pm UTC](https://forums.toadworld.com/t/change-script-always-includes-add-table-for-two-tables/58879 "2024-02-01T23:27:36Z")
Toad Data Modeler (v7.3) always generates "Create Table" statements for two tables in my model. These tables were included in the design (model) two months ago. They exist in the SQL Server 2019 database. They are in the… --- ## [Script generation for SQL Server - how to add 'use \' at the beginning of the script](https://forums.toadworld.com/t/script-generation-for-sql-server-how-to-add-use-database-at-the-beginning-of-the-script/40223)
**Author:** [@costabas](https://forums.toadworld.com/u/costabas)\ **Replies:** 2\ **Last updated:** [February 1, 2024, 10:43pm UTC](https://forums.toadworld.com/t/script-generation-for-sql-server-how-to-add-use-database-at-the-beginning-of-the-script/40223 "2024-02-01T22:43:34Z")
Hello: I am working on database changes that involve the creation of new tables. Using the Actions mechanism in the DDL Script Generation dialog I generate scripts for the set of tables I added, and I usually set Check … --- ## [REDATAMigratorDBMS12 Description: 'undefined' is null or not an object](https://forums.toadworld.com/t/redatamigratordbms12-description-undefined-is-null-or-not-an-object/58195)
**Author:** [@msdn](https://forums.toadworld.com/u/msdn)\ **Replies:** 10\ **Last updated:** [October 4, 2023, 9:21am UTC](https://forums.toadworld.com/t/redatamigratordbms12-description-undefined-is-null-or-not-an-object/58195 "2023-10-04T09:21:37Z")
Hello there, trying to reverse engineer a SQL Server 2019 database and getting this error. Any idea how to identify more precisely the problem? It specifies as well Row: 8506 Column: 3 How does this help? --- ## [Few questions from a returner](https://forums.toadworld.com/t/few-questions-from-a-returner/58047)
**Author:** [@Darkpsi](https://forums.toadworld.com/u/Darkpsi)\ **Replies:** 1\ **Last updated:** [August 29, 2023, 7:31am UTC](https://forums.toadworld.com/t/few-questions-from-a-returner/58047 "2023-08-29T07:31:01Z")
Hello TDM Community, After some years working with another data modeler tool (different company) I returned to Quest TDM product and have a few questions for the start. I installed the latest TDM Version 7.3. Does TDM… --- ## [Tweaking reports javascript?](https://forums.toadworld.com/t/tweaking-reports-javascript/57854)
**Author:** [@eric.mamet](https://forums.toadworld.com/u/eric.mamet)\ **Replies:** 1\ **Last updated:** [August 10, 2023, 5:27am UTC](https://forums.toadworld.com/t/tweaking-reports-javascript/57854 "2023-08-10T05:27:52Z")
Many years ago, it was possible to customise reports by tweaking the underlying javascript in templates. I just downloaded an evaluation of Toad Data Modeler and it looks like this is not possible anymore... Is there … [Next page](https://forums.toadworld.com/c/toad-data-modeler/15.md?page=1)