[CAY-2600] Modeler DbImport: Can't retrieve schema for databases with no catalog support

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.B2
• Fix Version/s: 4.1.RC1, 4.2.M1
• Component/s: Modeler
• Assignee: Arseni Bulatski
• Reporter: Andrus Adamchik
• Created: 19/Jul/19 13:35
• Updated: 03/Sep/19 07:56
• Resolved: 26/Aug/19 14:43

Description

I am trying to db-import model for Hana DB. DB Import itself ("Run Import" button) works, if I manually add all the settings. However "Refresh DB Schema" button results in an empty schema.

The cause of it seems to be the implementation of DatabaseSchemaLoader.load method. It looks for catalogs, and if none found, returns an empty result. Hana does not support catalogs, but supports schemas. And we need to support this case.

I guess in general we need to support all combinations of schema and catalog presence across different databases:

1. Schema and Catalog
2. Catalog only (MySQL)
3. Schema only (Hana ... who else?)
4. No schema or catalog (any DBs like this?)

Issue Links

• incorporates: CAY-2598 Oracle dbImport bug