Oracle URI Format

The Uniform Resource Identifier (URI) definition for Oracle follows this standard:

Identifier Fragments

• Namespace: oracle://{host}:{port}
  • Scheme = oracle
  • Authority = {host}:{port}
• Unique name: {database}.{schema}.{table}

Asset URI Format

• oracle://{host}:{port}/{database}.{schema}.{table}

Schema URI Format

• oracle://{host}:{port}/{database}.{schema}

Parameter Limitations

• host identifier must start with a lowercase letter and include only lowercase letters, numbers, dash and dot (regex: [a-z][a-z0-9-.]+)
• port number must include only numbers
• database name must start with a letter and include only lowercase and uppercase letters, numbers, underscore, dollar and # (Regex: [a-zA-Z][a-zA-Z0-9_$#]*). This parameter must match the DB_UNIQUE_NAME parameter you can find in Oracle.
• schema and table can have two formats, following Oracle naming standards: quoted format and unquoted format
  • unquoted identifier must include only lowercase letters, uppercase letters, numbers, underscore, dollar, and # (regex:[a-zA-Z][a-zA-Z0-9_$#]* )
  • quoted identifier must be enclosed in double quotes (") and must include only characters included in the Unicode range U+0001 to U+007F, excluding double-quote character.

Asset Examples

• oracle://sifflet-dev-oracle.bu2ngc.eu-west-1.rds.amazonaws.com:1521/database_name.schema.table_name
• oracle://sifflet-dev-oracle.a2ngc.eu-west-1.rds:1521/data$ba_se."{SCh1234^_$#A"."tABle1234_?$#my]_"

Schema Examples

• oracle://sifflet-dev-oracle.bu2ngc.eu-west-1.rds.amazonaws.com:1521/database_name.schema
• oracle://sifflet-dev-oracle.a2ngc.eu-west-1.rds:1521/data$ba_se."{SCh1234^_$#A"