Connect to your Amazon RDS instance.

AmazonRDSReader Properties

  • databaseName (Inline Only): The name of the database.
  • databaseType (Inline Only): The type of the database (either Postgres or MySQL).
  • sqlQuery (Inline Only): The SQL query to run in the database.
  • instanceConnectionName (Env First): The instance connection name.
  • username (Env First): The username for the database.
  • password (Env First): The password for the database.
Example with Environment Credentials
-
    name: myConnectorName
    type: AmazonRDSReader
    properties:
      databaseName:  myDatabase 
      databaseType:  Postgres 
      sqlQuery:  SELECT * FROM test 
    #schemaRef: schemaName # optional from "schemas:"
Example with Inline Credentials
-
    name: myConnectorName
    type: AmazonRDSReader
    properties:
      databaseName: myDatabase 
      databaseType: Postgres 
      sqlQuery: SELECT * FROM test 
      instanceConnectionName: connectionName 
      username: myUser 
      password: myPassword1 
    #schemaRef: schemaName # optional from "schemas:"

AmazonRDSWriter Properties

  • databaseName (Inline Only): The name of the database.
  • databaseType (Inline Only): The type of the database (either Postgres or MySQL).
  • tableName (Inline Only): The tablename associated with the action. Required for both read and write. For reading data, the query is used for selection.
  • instanceConnectionName (Env First): The instance connection name.
  • username (Env First): The username for the database.
  • password (Env First): The password for the database.
Example with Environment Credentials
-
    name: myConnectorName
    type: AmazonRDSWriter
    properties:
      databaseName:  myDatabase 
      databaseType:  Postgres 
      tableName:  myTable 

Example with Inline Credentials
-
    name: myConnectorName
    type: AmazonRDSWriter
    properties:
      databaseName:  myDatabase 
      databaseType:  Postgres 
      tableName:  myTable 
      instanceConnectionName:  connectionName 
      username:  myUser 
      password:  myPassword1