Release Information

Introduction

Getting Started

Delphix Engine System Administration

Virtual Database Management with the Delphix Engine

Data Backup and Recovery

Delphix Modernization Engine

Delphix Masking

Virtualizing Unstructured Files in the Delphix Engine

Virtualizing Oracle E-Business Suite in the Delphix Engine

JetStream

Mission Control

Delphix Express User Guide

Reference


Documentation for Previous Versions of the Delphix Engine

Delphix Server 3.0 Documentation
Delphix Server 3.1 Documentation
Delphix Engine 3.2 Documentation
Delphix Engine 4.0 Documentation
Delphix Engine 4.1 Documentation
Delphix Engine 4.2 Documentation
Delphix Engine 4.3 Documentation

Skip to end of metadata
Go to start of metadata

Delphix stores database connection information in an object called a "Connector." When in an Environment Overview, click the Connector tab to view the list of connectors within an environment.

  • For each connection, you must manually define a corresponding connector with the same name.

The Connector List

The Connector List screen shows the connectors that have been created within the environment.
 

Figure 10 Connector List Screen

Creating or Editing a Connector

To edit a connector:

  1. Click the Edit icon to the right of the connector.

To create a new connector:

  1. Click Create Connection to the upper right of the Connectors Editor.
    The Create Connection window appears, prompting you for connection information for a database or file:
    1. DB Type — Select the appropriate database type (for example, Database - Oracle) or file type (for example, File - Delimited).
    2. Each new connector uses the source system access credentials so appropriate access is granted when reading source data.

Deleting Connectors

To delete a connector:

  • Click the Delete icon to the far right of the connector name.
  • When you delete a connector, you also delete its rule sets and inventory data.

Database Connectors

The fields that appear are specific to the DBMS Type you select. If you need assistance determining these values, please contact your database administrator. All required fields are marked with an asterisk on the screen.

  • You only can create connectors for the databases and/or files listed. If your database or file type is not listed here, you cannot create a connector for it.
  • Kerberos Authentication — (Sybase, Oracle, or DB2 only, optional) Whether to use a Kerberos connection to the database. This box is clear by default. If this box is checked, the application code makes a Kerberos connection to the database instead of using a login/password.
  • Connection Type — (Oracle or MS SQL Server only) Choose a connection type:
    • Basic — Basic connection information.
    • Advanced — The full JDBC connect string.
  • Connection Name — The name of the database connector (specific for your Delphix application).
    • For each Connection Name, you must manually define a corresponding connector with the same name.
  • Schema Name — The schema that contains the tables that this connector will access.
  • Database Name — The name of the database to which you are connecting.
  • Host Name / IP or Hostname/IP—The network host name or IP address of the database server.
  • Username — (Oracle only)
  • ODBC DNS Name — (ODBC and Microsoft Access only)
  • Login ID — The user login this connector will use to connect to the database.
  • Password — The password associated with the Login ID or Username. (This password is stored encrypted.)
  • System Number — (SAP only)
  • SAP Client — (SAP only)
  • Language — (SAP only)
  • Port — The TCP port of the server.
  • SID — (Oracle only) Oracle System ID (SID).
  • Instance Name — (MS SQL Server only) The name of the instance. This is optional. If the instance name is specified, the connector ignores the specified "Port" and attempts to connect to the "SQL Server Browser Service" on port 1434 to retrieve the connection information for the SQL Server instance. If the instance name is provided, be sure to make exceptions in the firewall for port 1434 as well as the particular port that the SQL Server instance listens to.
  • Server Name — (Informix only) The name of the Informix server.
  • Custom Driver Name — (Adabas and SQL Anywhere only) The name of the custom driver.
  • Custom JDBC URL — (Adabas and SQL Anywhere only) The name of the custom JDBC URL.

All database types have a Test Connection button at the bottom left of the New Connector window. We highly recommend that you test your connection before you save it. Do so before you leave this window. When you click Test Connection, Delphix uses the information in the form to attempt a database connection. When finished, a status message appears indicating success or failure.

File Connectors

The values that appear correlate to the File Type you select. All required fields are marked with an asterisk on the screen.

  • Connector Name — The name of the file connector (specific to your Delphix application and unrelated to the file itself).
  • Connection Mode — Local Files, SFTP, FTP, HTTP & HTTPS.
  • Path — The path to the directory where the file(s) are located.
  • Operating System — Choose the operating system on which the file resides: Windows or Linux. (This value does not appear for Mainframe Copybooks.)

If you select SFTP or FTP for Connection Mode, the following additional values appear:

  • Server Name — The name of the server used to connect to the file.
  • User Name — The User Name to connect to the server.
  • Public Key Authentication — (Optional) (Only appears for SFTP.) Check this box to specify a public key.

When you check this box, the Available Keys dropdown appears. Choose a key from the dropdown. (The path on the server to the location that contains the keys is configured in a Delphix property files.)

  • Password — The associated Password for the server.
  • Port — The Port used to connect to the server.