Oracle

Overview

Stigg’s integration with Oracle Database allows you to export your product catalog, customer, and subscription data directly to your Oracle instance for custom reporting and analysis.

Stigg’s native data export integrations are included in the Scale plan, and are also available as an optional add-on to the Growth plan. See Stigg’s pricing for more details.

View the full entity schema

See every table and column exported to your destination, organized by entity group.

Setting up the integration

Prerequisites

If your Oracle database is protected by security groups or other firewall settings, you’ll need Stigg’s static IP available to complete the first step below. Contact Stigg support for the current static IP.

Allow access

Create a rule in your security group or firewall settings to whitelist:

Incoming connections to your host and port (usually 1521) from Stigg’s static IP.
Outgoing connections from ports 1024 to 65535 to Stigg’s static IP.

If your database can’t be made reachable via a static IP, you can connect over an SSH tunnel instead. This requires a bastion host that allows inbound SSH from Stigg’s static egress IP, with an SSH user configured using Stigg’s public key, and access from the bastion host’s IP to the database port. Contact Stigg support for the public key.

Create a writer user

Connect to your database and create a dedicated user for Stigg:

CREATE USER <username> IDENTIFIED BY '<some-password>';
GRANT CREATE SESSION TO <username>;

Then grant it the privileges needed to create, read, and write the synced tables:

GRANT CREATE SESSION TO <username>;
GRANT ALTER USER TO <username>;
GRANT CREATE ANY TABLE TO <username>;
GRANT CREATE ANY INDEX TO <username>;
GRANT SELECT ANY TABLE TO <username>;
GRANT INSERT ANY TABLE TO <username>;
GRANT UPDATE ANY TABLE TO <username>;
GRANT DELETE ANY TABLE TO <username>;
GRANT DROP ANY TABLE TO <username>;
GRANT COMMENT ANY TABLE TO <username>;

In Oracle, schema is synonymous with user — by default a new schema is created automatically on first sync. If the schema already exists, make sure the writer user has the proper permissions on it.

Connect Stigg with Oracle

In Stigg, navigate to Integrations > Apps > Oracle.Enter the following information in the connection form:

Field	Description
Host	The hostname or IP address of your Oracle server
Port	The port Oracle listens on. Defaults to `1521`.
Database	The name of the target database or service name
Schema	The schema where Stigg will create and sync tables
Username	The Oracle user Stigg will authenticate as
Password	The password for the Oracle user

Click Test & connect.

Select entities to export

After entering your connection details, expand the Entities to export section to choose which entity groups to include in the sync. All groups are selected by default.See Exported entities for a description of each group.

Getting started

Developer tools

Governance (Private Beta)

Modeling your pricing in Stigg

Entitlements

Managing customers, subscriptions and contracts

Getting usage data into Stigg

Snap-in widgets

Native integrations

Importing and exporting data

Going live

Workflow automation

Rolling out pricing changes with confidence

Price localization

Managing your account

High-availability and scale

Security & compliance

Overview

View the full entity schema

Setting up the integration

Prerequisites

​Overview

View the full entity schema

​Setting up the integration

​Prerequisites

Overview

Setting up the integration

Prerequisites