Oracle connector bug with cases

[brown3007]

Affected module
Oracle connector (backend)

Describe the bug
When using SQLAlchemy Inspector in Oracle connector we face a problem with case sensitivity/insensitivity
If we check Oracle case insensitive table/schema/column names, they all will be uppercase
SQLAlchemy sees all them lowercased

To Reproduce

The bug we found:
In Oracle we have two tables with same name except for case (Oracle allows us to do so):

But if we see them in OpenMetadata:

They have completely similar structure and (probably) changed casing.

Expected behavior
We expect table/column/schema names to be shown as they are in source system (Oracle).

Version:

• OS: Ubuntu Linux/Kubernetes
• Python version: 3.9
• OpenMetadata version: 1.3.2-1.4.8

Additional context
The problem was described here:
#15471 (comment)

[AlexeySmirnov74]

i have same problem

[KsM00000]

I have found bugs which I think related to the problems with case sensetivity:

1. problems with displaying lineages of the tables and views with the same names (issue Oracle lineage issues with tables and views of the same name #17971)
2. problems with links to the tables of the foreign keys
   Ex. we have a table 'A' which has a key to the table 'B'. When I trying to go to the table 'B' by clicking on the link on the frame 'Table Constraints' I get an error "table instance for ... not found". I realized that this is due to the fact that the table name on the frame is in lowercase letters ('b'), while the table itself is in uppercase.

[datapopcorn]

same problem here~