Companion for Integration - Validation

Companion for Integration - Validation is an online service that aims to ease the development of Companion for Integration configuration files.

Goals

Writing configuration files can be tricky. Any configuration change must be validated in a test database. This can be done in a very fast way using this tool.

Companion for Integration - Validation provides a sandbox to test configuration files online, without any installation required. Its interface allows configuration and StepXML files to be uploaded and edited on-the-fly. Resulting tables, documents, etc. can then be reviewed on the same page, and the configuration can be adjusted and submitted again in one-click.

Interface

1. Text editor
2. Load a file into the editor
3. Select a destination
4. Submit data for validation

Read Planned features for a non-exhaustive list of upcoming destinations.

MySQL

Below is a typical output for MySQL.

Each table produced by the query is summarized in its own pannel. It can be inspected and sorted.

1. Name of the table and its size in rows
2. Expand or collapse the table
3. Name of the column

Hover a column's name to indicate its type. Click on it to sort the table's rows according to this column.

MongoDB

Each table produced by the query is summarized in its own pannel.

1. Name of the collection and its size in documents
2. Copy the collection as JSON
3. Expand or collapse the collection
4. Documents, sub-documents and their fields

The fields of every document are listed, along with their values and their BSON types. Some values are displayed differently:

• JSON objects are displayed as nested documents (without an _id field)
• Dates and timestamps are displayed in the current locale