Skip to content

Latest commit

 

History

History
executable file
·
72 lines (53 loc) · 2.95 KB

README.md

File metadata and controls

executable file
·
72 lines (53 loc) · 2.95 KB
Raw

AutoPower

What is this?

AutoPower is a project to automate the creation of IBM Datapower Gateway Multi-Protocol gateways.
A Multi-Protocol Gateway is a middleware that exposes a backend (web service, database stored procedure, queues, etc.) through a frontend (tipically a RESTful or SOAP web service).
For now Autopower supports DB stored procedure as backend.

TODO Support other backends

How to

Requirements

To run AutoPower, you need to follow the following steps:

  • Clone this repository
  • Follow this instructions
  • Finally, in the root of the project, run:
gradle clean test

How it works?

AutoPower connects to a database using JDBC and extracts metadata of all stored procedures of one catalog and schema. Then, AutoPower create a template XML with the stored procedure data and inject in a folder for default of a Multi-Protocol Gateway. Finally, the folder generated is compresssed and are ready to import in DataPower Hardware.

Detailed steps

Autopower generates one file: procedures.json which contains a list of all stored procedures. Each stored procedure has a name and parameters. Parameters are grouped as: In, Out, InOut, Result and Unknown.

[
    {
        "name": "dm_cryptographic_provider_algorithms;0",
        "Result": [
            {
                "columnName": "@TABLE_RETURN_VALUE",
                "dataType": null,
                "typeName": "table"
            }
        ],
        "In": [
            {
                "columnName": "@ProviderId",
                "dataType": "INTEGER",
                "typeName": "int"
            }
        ]
    },
...

To generate procedures.json file, AutoPower work on a file created for us :

  • typeNames.json. This was created starting a extension of IBM DataPower called sql-execute for the mapping from SQL type names (according to IBM DataPower) to engine specific data types.
  • columnTypes.json. This was created to map out the stored procedure with the values of default to replace their for understandable names.

This you can found in MetaDBBuilder.groovy file.

To generate a template XML file, AutoPower use Hogan to inject stored procedures metadata in a DataPower object template. This you can found in RenderBuilder.groovy file.

TODO

What is next?

  • Add support for Sybase
  • Complementary README.md