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,

The easiest way to import data into the HOPEX repository is through the Excel import functionality:

There are a number of pre-defined templates to use (which can be customized), or you can easily build your own.
There are also two modules that provide enhanced import templates

• ITBM Excel Import Template
• ITPM Excel Import Template

Kenneth

[faisalbashir517]

Dear Kenneth,
I need to implement one thing I need your suggestions, 
I have data from oracle database and I want to post this data to Mega hopex Metaclass is there any way where I can get the data object accepted by the mega hopex, I have data in JSON form 

[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