Messages

1

General Board / Re: How to configure ODBC conection for Oracle DB

« on: September 26, 2018, 07:39:29 am »

Use the OLE DB driver - you'll find it's quicker than the ODBC driver...
http://www.sparxsystems.com/enterprise_architect_user_guide/14.0/model_repository/oracle_data_reposity_ole_db.html

2

Bugs and Issues / Re: EA 14 Import DB fails

« on: June 21, 2018, 08:00:18 am »

Sequences are not supported in SQL Server 2008.  Set Sequences to False in the Object Filters section of the "Import DB schema from ODBC source" dialog.

3

Automation Interface, Add-Ins and Tools / Re: Oracle Reverse Engineer

« on: May 29, 2018, 08:20:48 am »

Make sure the ODBC driver is the Oracle driver and not the "Microsoft ODBC for Oracle" driver.

4

Bugs and Issues / Re: New MariaDB error when setting up a new Repo.

« on: May 10, 2018, 08:35:34 am »

MySQL ODBC Connector 5.3.4 works.

5

Bugs and Issues / Re: SQL Server Reverse on views: truncated definition

« on: April 23, 2018, 08:05:41 am »

Upgrade to EA version 13.5?

6

General Board / Re: Querying multiple optional tag values in SQLServer

« on: April 13, 2018, 07:52:33 am »

Aliases are wrong?

tv1.Value AS tv1,
tv2.Value AS tv1,
tv3.Value AS tv1,
       ...

should be...
tv1.Value AS tv1,
tv2.Value AS tv2,
tv3.Value AS tv3,
       ...

7

General Board / Re: XMI import problem

« on: February 23, 2018, 02:51:55 pm »

I think you'll find the key in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\...

8

General Board / Re: Reverse Engineering a MySql db (RDS on AWS)

« on: January 17, 2018, 12:42:33 pm »

Are you using the 32-bit MySQL ODB Driver?  See the first Note at the bottom of page...

http://www.sparxsystems.com/enterprise_architect_user_guide/13.5/model_domains/importdatabaseschemafromod.html

9

General Board / Re: Database Builder, MySQL, INT, unsigned as default attribute

« on: January 08, 2018, 07:43:48 am »

Database Builder | Columns...
http://www.sparxsystems.com/enterprise_architect_user_guide/13.5/model_domains/dbexplorer.html

Column Properties...
http://www.sparxsystems.com/enterprise_architect_user_guide/13.5/model_domains/createcolumns.html

10

General Board / Re: Database Engineering: Remove Schema on import

« on: June 20, 2017, 07:48:21 am »

http://sparxsystems.com/enterprise_architect_user_guide/13.0/model_domains/manage_dbms_settings.html

11

General Board / Re: Is there a way to suppress columns for some tables in a diagram?

« on: June 13, 2017, 08:26:05 am »

Diagram Properties | Elements | Show Compartments - disable Attributes.

12

General Board / Re: Database Builder: More than on connection

« on: June 09, 2017, 07:36:02 am »

No.  The Database Builder can only compare an EA data model with a live database...
http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_domains/import_schema_into_builder.html

13

Bugs and Issues / Re: After upgrading canīt access to my Oracle Data Repository

« on: March 29, 2017, 07:45:30 am »

Maybe you are using a 64-bit Oracle client.  EA only works with 32-bit clients.

14

General Board / Re: int, identity column

« on: March 29, 2017, 07:43:53 am »

Select your table in the Database Builder, select your identity column, set AutoNum to true in column properties list at lower left.

15

General Board / Re: int, identity column

« on: March 28, 2017, 01:35:57 pm »

Database Builder - Column Properties...
http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_domains/createcolumns.html