AlchemyJ Features

Generate Java, REST and JavaScript APIs from Excel.
Build APIs in Seconds
Support user friendly to advanced database operations.
Database Integration
Enable data validation and transformation in APIs.
Data Dictionary
Support authentication, access and session management.
API Security
Support real-time and interactive API troubleshooting.
Interactive Debugger
Verify the generated API has the same functionality as the Excel Model.
Automatic Testing Framework
Generate OpenAPI (Swagger)specification and interface automatically.
OpenAPI (Swagger) Support
Support multi-workbook modelling and API development projects.
Multi-Developers Project
Provide 50+ AlchemyJ extended and 300+ Excel functions.
300+ Functions in Excel
Provide a framework for building AlchemyJ user defined functions.
Unbounded Extensibility
Generate Java, REST and JavaScript APIs from Excel.

Generate Java, REST and JavaScript APIs from Excel.

With just a click, AlchemyJ could analyze the business models in Excel spreadsheets, then it generates the Java, REST or JavaScript API that implements all the business logic as well as the technical specification contained in the Excel spreadsheet. Users can start from a blank spreadsheet or a pre-defined API template with all the necessary configurations ready so they only need to put in their own logic, then have the API generated instantly.

Support user friendly to advanced database operations.

Support user friendly to advanced database operations.

Database integration is a critical part of most enterprise API. AlchemyJ provides a set of Extended Functions in Excel for all database operations, such as Create, Read, Update and Delete (CRUD). The AlchemyJ Extended Functions encapsulates low-level complexity of database operations, so even users without SQL knowledge could manage database access. For advanced users, AlchemyJ allows them to issue native SQL commands so the generated API could tap into the native powerful features of the Databases.

Enable data validation and transformation in APIs.

Enable data validation and transformation in APIs.

Without stringent control to the input and output parameters of the API, the API will be prone to error. The data dictionary allows not only users to define various attributes of data but also provides a template for the completeness in the requirements collection process. Based on data attributes, AlchemyJ applies validation and transformation logic to the input parameters. In addition, it also enforces that data returned from API conforms with the attributes specified in the data dictionary.

Support authentication, access and session management.

Support authentication, access and session management.

The security of API from AlchemyJ is divided into three stages. The first stage is the authentication. AlchemyJ API supports various authentication, such as LDAP. The second stage is access control. AlchemyJ API checks the role and group of authenticated users and determines if the API access is allowed. The third stage is session management, for instance, AlchemyJ manages encrypted information exchanges between API servers and clients, as well as a session timeout.

Support real-time and interactive API troubleshooting.

Support real-time and interactive API troubleshooting.

AlchemyJ provides a debugger for real-time monitoring on the API execution. The debugger shows variables' value as well as execution formulas in different execution states of the API. AlchemyJ also provides debugging commands for interactive troubleshooting. Based on the commands specified, AlchemyJ will extract or execute corresponding information or operations during the API execution. While security is AlchemyJ's top priority, all debugging functions could be removed in the production environment.

Verify the generated API has the same functionality as the Excel Model.

Verify the generated API has the same functionality as the Excel Model.

AlchemyJ provides an Automatic Testing Tool in Excel. The tool lets users define test cases and runs the cases automatically. With a proven model, AlchemyJ could augment the test cases in order to increase the testing coverage. Then the Test Case Transformation Engine of AlchemyJ will transform Excel test cases to cases in Java or REST API. Once the API is generated, AlchemyJ will execute the cases in Java and REST API automatically to assure the functionality of API meeting the requirements.

Generate OpenAPI (Swagger)specification and interface automatically.

Generate OpenAPI (Swagger)specification and interface automatically.

AlchemyJ eliminates the trouble of API documentation by automatically generating OpenAPI (Swagger) specification based on the model defined in Excel. The OpenAPI specification contains API description, usage guidelines, endpoint specification, request parameters, response details, authentication, etc. The specification also comes with an interactive API trial interface. The interface lets users try the API with user-specified requests and responses as if it is running in the API consumer modules.

Support multi-workbook modelling and API development projects.

Support multi-workbook modelling and API development projects.

AlchemyJ supports multi-developers (multi-analysts) API development projects. This maximizes the efficiency of complex API model. The idea of the multi-developers project in AlchemyJ is similar to the Divided-and-Conquer approach. Users can break down a complex model into a number of simple models. Each of the simple models is contained in a separate workbook and handled by an individual developer. AlchemyJ will combine all simple models into a solution for the complex model.

Provide 50+ AlchemyJ extended and 300+ Excel functions.

Provide 50+ AlchemyJ extended and 300+ Excel functions.

AlchemyJ supports over 300 Excel functions. Moreover, in order to better meet the requirements of enterprise application or API, AlchemyJ provides more than 50 extended functions in Excel, such as email, file operations, even calling other REST API or Java functions. The AlchemyJ extended functions are comprehensive toolkits for the modeling of any business requirements.

Provide a framework for building AlchemyJ user defined functions.

Provide a framework for building AlchemyJ user defined functions.

Despite the rich functions provided by AlchemyJ in Excel, there are circumstances that users need to build their own functions to extend the functionality of their business model and API. AlchemyJ provides a Framework for building AlchemyJ User Defined Function (AJUDF) in VBA and Java. While users could use VBA based AJUDF in their Excel models, AlchemyJ will call the corresponding Java-based AJUDF in the API. Transformation of AJUDF call, control and handling of return and error will automatically be done by AlchemyJ.