The next step in setting up DB Connect is to create at least one Connection. You'll need to obtain the host, port, and default database information for the database you're going to be connecting to from your DBA before proceeding with the following steps:
- Click the Databases | Connections tab and then click New Connection.
- Give the Connection a unique Name (you'll reference this when setting up Input, Output, or Lookups).
- Select the previously-configured Identity.
- Select a Connection Type from the list of database types, such as MS SQL Server, Oracle or MySQL.
- (Optional) Set a Timezone to apply to the Timestamp fields (or allow the JVM timezone setting to be applied)—this might apply if your timestamps don't include a TZ indicator ...