MS SQL Server, MySQL, PostgreSQL, Oracle, IBM Db2 MySQL, MS SQL Server, PostgreSQL, Oracle, IBM Db2 MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2Īccess, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2 Windows, Linux (Wine), macOS (via CrossOver)ĭata modeling is supported as part of a complete modeling platform.Īccess, Snowflake, Microsoft Azure IBM Db2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQLĪccess, IBM Db2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQL IBM Db2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase Windows, Linux and FreeBSD (both through Wine) MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB Standalone or bundled into a larger toolkit This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment. Lastly press the “Connect” button.įrom here CA ERwin Data Modeler will reverse engineer your Excel spreadsheet into a CA ERwin Data Modeler model.Comparison of notable data modeling tools Under the “ODBC Data Source” select your ODBC data source, as was created in earlier steps. IN the ODBC Connection screen, ensure the database is “ODBC 3.x”. On the Reverse Engineering – Set Options screen, select the “System Objects” option box, and then press the “Next” button.
Then select the Target Server to be an “ODBC” database, and the version as “3.x” (though 2.0 also works with no problems).
On the New Model screen, select the type of model that you want to create. In CA ERwin Data Modeler, open the Reverse Engineering tool (Actions -> Reverse Engineer…). Import Excel spreadsheet into CA ERwin Data Modeler. On returning to the ODBC Microsoft Excel Setup screen, you can press the “OK” button.Ĭonfirming that you have successfully created your new ODBC connection in the ODBC Data Source Administrator, you can now proceed to open CA ERwin Data Modeler. Navigate to and select the relevant Excel spreadsheet that you want to reverse engineer. NOTE: The version of Excel only shows “Excel 97-2000”, but it works with spreadsheets created in Excel 2003 too. Then click on the “Select Workbook…” button. You can also provide a description, if you like. On the ODBC Microsoft Excel Setup screen, give your “Data Source Name” a value that is representative of your Excel Spreadsheet. On the Create New Data Source screen, select the “Microsoft Excel Driver” driver, then press the finish button. On the User DNS tab, click the “Add” button. o Open your ODBC Data Source Administrator. If you have a 64bit machine, you can access the 32bit ODBC Data Source Administrator by using the ‘C:\Windows\SysWow64\odbcad32.exe’ ODBC Data Source Administrator application. NB: Make sure that it is a 32bit ODBC connection and not a 64bit ODBC connection. Create an ODBC connection to your spreadsheet. The Microsoft ODBC exposure of the spreadsheet only works with. If it is not, then save the Excel file into this format, using the “File -> Save As” functionality.
Make sure that the Excel spreadsheet is an Excel 97-2003 file format (.xls) and not a newer file format (.xlsx or. Where each of the Sheets in the Excel Spreadsheet are representative of an entity/table, and each of the columns in the sheet are representative of an attribute/column in the entity/table, named by the first row in the sheet. Reverse Engineer an Excel Spreadsheet into CA ERwin Data Modeler Description: As a CA ERwin user, you want to be able to reverse engineer an Excel spreadsheet into a CA ERwin Data Modeler model.