Connect to a JDBC database with Lingk provided drivers

JDBCReader Properties

  • databaseName (Inline Only): The name of the database.
  • username (Inline Only): The database username.
  • password (Inline Only): The database password.
  • host (Inline Only): The host domain or IP address.
  • sqlQuery (Inline Only): The SQL Query to read data from the database.
  • port (Inline Only): The port of the database host (default: 5432)
  • driver (Inline Only): The driver type. Supports: postgresql-42.1.1, sqlserver
Example with Inline Credentials
-
    name: myConnectorName
    type: JDBCReader
    properties:
      databaseName: testDatabase 
      username: myUser 
      password: xxx 
      host: my.database.com 
      sqlQuery: SELECT * FROM testTable 
      port: 5432  # optional 
      driver: postgresql-42.1.1 
    #schemaRef: schemaName # optional from "schemas:"

JDBCWriter Properties

  • databaseName (Inline Only): The name of the database.
  • tableName (Inline Only): The table to be written to.
  • username (Inline Only): The database username.
  • password (Inline Only): The database password.
  • host (Inline Only): The host domain or IP address.
  • port (Inline Only): The port of the database host (default: 5432)
  • driver (Inline Only): The driver type. Supports: postgresql-42.1.1, sqlserver
Example with Inline Credentials
-
    name: myConnectorName
    type: JDBCWriter
    properties:
      databaseName:  testDatabase 
      tableName:  testTable 
      username:  myUser 
      password:  xxx 
      host:  my.database.com 
      port:  5432  # optional 
      driver:  postgresql-42.1.1