Problem In Office Visio 2003, trying to use reverse engineer, “ Oracle server” as Visio driver to create entity-relationship diagram or ERD from Oracle 11 G. But, when Visio “ Extracting Oracle Object, type and body? XDB$ Complex_derivation.” A “ Encountered a fatal error during reverse engineer of information from database” message is prompt and the process is stopped. Solution Look like the default Visio 2003 Oracle driver is unable to process some of the Oracle 11g objects found in the reverse engineer process, may be some 11g features are too new for Visio 2003? However, the workaround is choose the “ ODBC Generic Driver“, instead of “ Oracle Server” as the Visio connector driver, see figure below : Done, now, the Visio 2003 is able to generate ERD via reverse engineer from Oracle.
A previous article covered some of the features of Visio, The Microsoft Office Business and Technical Diagramming Program. One of Visio's key features is its ability to reverse engineer a database, and in this article, we will take a look at doing exactly that using the sample schemas Oracle provides. Comparing the results of Visio's reverse engineering and the schema diagrams illustrated in the Oracle Database Sample Schemas documentation, and seeing how well they match should give you some confidence in Visio's features. The version of Visio used in these examples is the Professional 2003 edition. Although the Professional edition is obviously more advanced than the standard version, you cannot forward engineer a schema, that is, once you have created the entity relationship diagram or model, there is not a feature that generates the data definition language for you. However, this forward engineering feature is available in the Visual Studio. NET Enterprise Architect ( VSEA) version. The cost of VSEA is around 00, but may be available for less through a reseller. Click for larger image Getting started If you can connect to a schema in SQL* Plus, you will be able to connect to it using Visio. Microsoft provides a driver for Oracle and you can select a specific driver for the version of Oracle you are using. To create the schema diagram for the HR user in Oracle9i/10g, I selected the tables from HR and opted to show the primary and foreign keys. Given that the number of tables is small (only seven Visio has no problem with placing the objects in the diagram. With a larger number of tables, Visio provides a warning about how the reverse engineering process may affect the model (the database) and that placing numerous objects directly in the drawing may take a significant amount of time. The end result of reverse engineering the HR schema is shown below. In.
I ran several different tests: 1) Set Visio Driver to Oracle Server, The Oracle 9i client and Visio Professions 2003 SP 2 ( ) and an Oracle 9i database I was able to reverse engineer Tables (primary keys, indexes, foreign keys, triggers, check clauses views, and stored procedures. I was able to view field and table comments and triggers. 2) Set Visio Driver to Oracle Server, the Oracle 10 G client and Visio Professions 2003 SP 2 ( ) and an Oracle 9i database I was able to reverse engineer Tables (primary keys, indexes, foreign keys, triggers, check clauses views, and stored procedures. 3) Set Visio Driver to Oracle Server, the Oracle 9i client and Visio Enterprise Architects SP2 ( ) and an Oracle 9i database I was able to reverse engineer Tables (primary keys, indexes, foreign keys, triggers, check clauses views, and stored procedures. 4) Set Visio Driver to Oracle Server, the Oracle 10 G client and Visio Enterprise Architects SP2 ( ) and an Oracle 9i database I was able to reverse engineer Tables (primary keys, indexes, foreign keys, triggers, check clauses views, and stored procedures. 5) Set Visio Driver to Oracle Server, the Oracle 10 G client and Visio Professions 2003 SP 2 ( ) and an Oracle 10 G database The application stops at Extracting Oracle Object type and body XDB$ Complex_derivation_ T and gives the message box Encountered a fatal error during reverse engineer of information from the database! 6) Set Visio Driver to Microsoft Access, the Oracle 10 G client and Visio Enterprise Architects SP2 ( ) and an Oracle 10 G database The application will only extract tables (primary keys, indexes, foreign keys, & check clauses) and views and gives the error Data Source Client Error: State: S1010, Native:0 origin:[ Mircorosft][ ODBC Driver Manager] Function Sequence error 7) Set Visio Driver.
Download Now