Characteristics of database adapters

Event triggers

Database sources can be used as source event triggers.

Wildcards

Wildcards cannot be used for database sources and targets.

Overrides

Database adapters can be used as an override for any source or target type.

Database connections

  • Database connections are coordinated across sources, targets, and database functions used in a single map instance. For example, if one database target is specified with a rollback option and that database is accessed by a DBLOOKUP function within any output, the connection will apply for data accessed in that function.
  • A connection to a database is specified for each unique combination of data-source name, user ID, password, rollback option and map instance. You can force a new connection, for example, by using different user IDs or data source names. You can take advantage of single connections for a particular map instance by keeping all the database specific parameters the same.

OnSuccess, OnFailure, and Retry settings

  • The OnFailure setting applies to modifications made to a database source or target within a particular map, burst or card instance (depending on the setting for Scope). For example, an OnFailure setting of Rollback specified for a source query applies only when that query references a stored procedure, which modifies the database
  • A database transaction is synonymous with a connection for the purposes of OnFailure and OnSuccess settings. The database transaction begins when the connection is established and ends when the map completes. If the map does not complete successfully and a rollback is associated with that transaction, the database transaction is rolled back. This means, for example, that if multiple sources and targets of the same map share the same connection and all have an adapter rollback specified, any modification made to any one of these sources or targets are part of the same database transaction
  • If a map does not complete successfully, all DBQUERY and DBLOOKUP functions used in that map always rollback. If a DBQUERY or DBLOOKUP function fails and the map succeeds, the function returns NONE, but any modifications to a database specified in the function will rollback.
  • The Retry option applies when attempting to connect to a database.
  • The OnSuccess option for a source or target is not supported. However, SQL delete statements and stored procedures used as sources can be used for deletion purposes.
    Note: If more than one map instance deletes the same data, the first map instance that completes will delete that data. Deleted database data is not coordinated among map instances.