Connecting to JDBC

In order for Spectrum™ Technology Platform to access data in a database using a JDBC connection, you must define the JDBC connection using Management Console. Once you do this, you can create flows in Enterprise Designer that can read data from, and write data to a database using JDBC.

  1. Open Management Console.
  2. Go to Resources > Data Sources.
  3. Click the Add button .
  4. In the Name field, enter a name for the connection. The name can be anything you choose.
    Note: Once you save a connection you cannot change the name.
  5. In the Type field, select type of database you want to connect to.

    Spectrum™ Technology Platform comes with JDBC drivers for SQL Server and Oracle databases. If you want to connect to a different database type, you must add the JDBC driver before defining a connection.

  6. 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

  7. 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.
  8. Click Save.
  9. Test the connection by checking the box next to the new connection and clicking the Test button .