Database AWS Importer for JSM Assets runs on the Forge Platform, which provides:
...
Additionally, Pio leverages AWS's serverless capabilities as a gateway to databasesAWS Accounts. The gateway functionality connects multiple databases AWS Accounts and imports data into multiple related 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 AWS Account to One Object TypeSchema
Multiple Tables from one Database to multiple Object Types in one Accounts to 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 Accounts to multiple Object Types in multiple Object Schemas hosted on multiple JSM Sites.
Drawio | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | Public IP Address for Outbound Traffic |
---|---|---|---|---|
US | AWS | North America (Virginia, US) | us-east-1 | 52.45.180.198 |
EU | AWS | Europe (Frankfurt, Germany) | eu-central-1 | 18.199.1.227 |
Integration with the database AWS Account 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 databaseAWS Accounts.