Connecting to a JDBC Database - data_integration_1 - discovery - spectrum_platform - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Reference
Overview
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

Define a connection using the Connections page. You can go to this page through Spectrum Management Console or through Spectrum Discovery.

  1. Access the Connections page using one of these:
    Spectrum Management Console:
    Access Spectrum Management Console using the URL: http://server:port/management console, where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform.
    Note: By default, the HTTP port is 8080.
    Click Resources > Connections.
    Spectrum Discovery:
    Access Spectrum Discovery using the URL: http://server:port/discovery, where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port used by Spectrum Technology Platform.
    Note: By default, the HTTP port is 8080.
    Click Connect.
  2. Click the Add connection button .
  3. In the Connection Name box, enter a name for the connection. The name can be anything you choose.
    Note: Once you save a connection you cannot change the name.
  4. In the Connection Type field, select type of database you want to connect to.

    Spectrum Data Federation includes JDBC drivers for SQL Server, Oracle, and PostgreSQL databases. If you want to connect to a different database type, you must add the JDBC driver before defining a connection.

  5. In the URL field, enter the JDBC connection URL. Your database administrator can provide this URL.

    For example, to connect to a MySQL database named "SampleDatabase" hosted on a server named "MyServer" you would enter:

    jdbc:mysql://MyServer/SampleDatabase

  6. There may be additional fields you need to fill in depending on the JDBC driver. The fields represent properties in the connection string for the JDBC driver you selected in the Type field. See the JDBC driver provider's documentation or your database administrator for information about the specific connection properties and values required by the connection type.
  7. Click Save.
  8. Test the connection by checking the box next to the new connection and clicking the Test button.