Home → Using LincDoc 3.0 → Database Lookups → Datasource configuration

13.2. Datasource configuration

A datasource defines the connection parameters to the database server. This database name is used to refer to the database when performing a query.

To configure a datasource:

  1. Go to the LincWare System Administration (LWSA) portal: https://servername/lwsa/
  2. Click the show details button next to JDBC connections:.
  3. Enter the database name.
  4. Select the JDBC ID (JDBC driver type).
  5. Enter the database username.
  6. Enter the password.
  7. Enter the database server name/IP address.
  8. Enter the TCP/IP port used to connect to the database server. Commonly used ports: MS SQL Server: 1433; Oracle: 1521; PostgreSQL: 5432; MySQL: 3306. Click here for more information on finding MS SQL server ports.
  9. Click the test button to ensure proper connectivity.
  10. Repeat these steps for every database that needs a connection. Note: LWSA only provides the ability to add one database at a time; you must save changes after adding each database.

Knowledge Tags
database  /  datasource  /  JDBC  / 

This page was: Helpful | Not Helpful
← 1. eForms design