Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
simple
mVer2
simple0
zoom1
0inComment0
custContentId337477665
pageId336855097606928986
lboxcustContentId1607092928
diagramDisplayNameUntitled Diagram-1675801755883.drawio
lbox1
contentVer31
revision42
baseUrlhttps://piosoftware.atlassian.net/wiki
diagramNameUntitled Diagram-1675801755883.drawio
pCenter0
width20302241.50000000000005
links
tbstyle
height839838.9999999999998

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.