Penta-Mapping

penta-mapping is a tool to extracts meta data from databases in a graph data structure in JSON format.

Features

• supports DBMS: MongoDb, MySql, and Oracle.
• configuration file with connection strings are read from a .json config file.
• output file describes graph data structure

And of course penta-mapping itself is open source as a private package on https://www.npmjs.com/

How to Use

penta-mapping requires Node.js v13+ to run. It takes three parameters: configFile, outputDirectory, and outputFile. As an example, you can execute the package using npx command as follow:

npx penta-mapping config.json . schema_all.json

Example of config.json:

{
    "configuration" : [
      {
        "DBMS"      : "MongoDB",
        "HOSTNAME"  : "localhost",
        "PORT"      : "27017",
        "ADMIN"     : "adminpassword",
        "TEST"      : "",
        "DATABASE"  : [ "Job_Network", "Student", "Grade"]
      },
      {
        "DBMS"      : "MySQL",
        "HOSTNAME"  : "localhost",
        "PORT"      : "3306",
        "ADMIN"     : "",
        "TEST"      : "",
        "USER"      : "root",
        "PASSWORD"  : "rootpassword",
        "DIALECT"   : "mysql",
        "DATABASE"  : ["job_database", "employees"]
      },
      {
        "DBMS"        : "Oracle",
        "HOSTNAME"    : "localhost",
        "PORT"        : "1521",
        "USER"        : "hr",
        "PASSWORD"    : "hr",
        "SERVICE_NAME": "XEPDB1",
        "OWNERS"      : ["HR"]
      }
    ]
}

License

Penta License