Oracle Connection

Create a PawSQL Workspace from a Oracle connection.

Requirements

• Oracle Database 19c, 18c, 12c or 11g.
• Make sure your database is accessible from the machine running PawSQL

Information Needed

When we choose a Oracle connection as the workspace type, we need to supply following connection information. PawSQL will connect to the database server and retrieve the table、view and indexes definition.

• Host * - The host name of the database.
• Port * - The port to connect to.
• Database * - The servcie name of the database.
• Schemes * - A list of schema names.
• Username * - The user name which is used to access the database.
• Password * - The password associated with the user name.

How to access your database from internet?

• Deploy PawSQL Cloud in your own environment, contact us at service@pawsql.com

• Amazon RDS or Aliyun RDS

• Set up a reverse proxy

  • ngrok https://github.com/inconshreveable/ngrok

  • frp https://github.com/fatedier/frp

  • lanproxy https://github.com/ffay/lanproxy

  • goproxy https://github.com/snail007/goproxy

  • nps https://github.com/cnlh/nps