Database Importer for JSM Assets runs on the Forge Platform, which provides:
Serverless Computing Platform
Rest API Interfaces
Secure Hosted Storage for configuration (data is not stored)
Scheduling Capability
Audit and Debug Logging
Additionally, Pio leverages AWS's serverless capabilities as a gateway to databases. The gateway functionality connects multiple databases and imports data into multiple object types. These object types can be in the same schema or separate schemas. They can even be hosted on different JSM sites. The following data transfer scenarios are possible:
One Table to One Object Type
Multiple Tables from one Database to multiple Object Types in one Object Schema
Multiple Tables from one Database to multiple Object Types in multiple Object Schemas
Multiple Tables from multiple Databases to multiple Object Types in multiple Object Schemas
Multiple Tables from multiple Databases to multiple Object Types in multiple Object Schemas hosted on multiple JSM Sites.
Forge currently supports data residency, which allows data to be stored in the same AWS region as our customers' JSM sites.
Pio Database Gateway is available in the US and EU regions. It doesn’t have a data store, and transactions are processed on the fly. The list of regions:
Pio Region Name | Service Provider | Location | Region Description |
|---|---|---|---|
US | AWS | North America (Virginia, US) | us-east-1 |
EU | AWS | Europe (Frankfurt, Germany) | eu-central-1 |
Integration with the database is read-only and one-way via the database connection.