Connecting to a JDBC Database

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.