What to Reverse Engineer: Select the Vertica objects you want to reverse engineer into DDL. Then enter the database user name and password. Select Data Provider: Select Connection via ODBC.Ĭonnecting: select the DSN you created in the previous section from the Datasource Name pulldown menu. Select Data Source: Select Vertica from the list. Name: Use any name pertinent to your organization. For each screen in the Connections dialog, enter the field information and click Next. In the Connections dialog, click the New Connection icon on the toolbar and add a new connection for the Vertica database DSN you created.You can also access this dialog by selecting File > Reverse Engineer > Connections or clicking the Connections icon. Press Ctrl-Alt-C to open the Connections dialog.If it is not already selected, select the Vertica checkbox. Select Menu > Settings > Add/Remove Database.With Toad Data Modeler running ,do the following to connect to Vertica: For example:Ĭonnecting to Toad Data Modeler to Vertica

In the Windows ODBC Data Source Administrator (64-bit), configure a 64-bit System DSN for the Vertica ODBC driver you installed and your Vertica database. When prompted to select one or more drivers, ensure to select the 64-bit ODBC driver.Ĭreate an ODBC DSN as described in the Creating an ODBC Data Source Name (DSN) section. Double-click the installer and follow the prompts.Note For details about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation. Go to the Toad Data Modeler download site and download the Toad Data Modeler (64-bit) version.Vertica ODBC driver 64-bit version 11.1.1 This document provides guidance using the software listed as follows: Software Vertica and Toad Data Modeler: Latest Versions Tested It also enables you to quickly generate complex SQL/DDL, create scripts, and reverse and forward engineer both databases and data warehouse systems. Toad Data Modeler allows you to construct logical and physical data models, and compare and synchronize these models. Connection guides are based on our testing with specific versions of Vertica and the partner product. Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Vertica Integration with Toad Data Modeler: Connection Guide About Vertica Connection Guides

Toad latest version