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:

Integration with the database is read-only and one-way via the database connection.

Security Recommendation

Add the Public IP Address of the Pio Database Gateway displayed in the table above to your network allow-list. Block all the other IP addresses trying to connect to your database.