Mega Database structure and columns

[faisalbashir517]

Hi everyone, 
I am new to MEga hopex I want to make some integration from oracle DB to mega system.

I have some queries need help from community,
-how I can know which database is connected to MEGA hopex?

- where I can see the structure of data,columns or keys in mega side for specific metaclass

[KennethB]

Hi,

HOPEX uses several databases where the name is based on the environment and repository name.

<environment name>_SystemDb
<environment name>_<repository Name>

HOPEX uses SQL Server as the database backend (not Oracle).

The table structure within the database is not designed to be read via SQL - there are not tables/colmuns for MetaClass and MetaAttributes.

Kenneth