Docs

Appearance

Flow documentation · legacy product

DB Connection (DBCon) ​

Declaration ​

Source.DBCons[0].DBCon : TFloDBCon

Dest.DBCons[0].DBCon : TFloDBCon

Description ​

The DB Connection object can be used to interact with the DB Connection during a mapping process. This provides access to properties of the db connection so they can be altered for this specific map.

You can access the db connection object by referencing Source.DBCons[0].DBCon or Dest.DBCons[0].DBCon, where Source and Dest are pointers to the source and destination data definitions of the map.

Usage ​

Among other things the following tasks can be achieved by working with the File Connection object

Access the Other Params property for storing custom configuration

You can use the Other Params property of the DB Connection to store custom configuration values. You can then access and modify these values using Source.DBCons[0].DBCon.OtherParams.Values['ParamName']

Retrieving the name of the database

You can determine the name of the database you are connecting to using Dest.DBCons[0].DBCon.Database. Handy for storing in log messages.

Retrieving the name of the user and their password

You can determine the name of the user you are connecting to the database with using Dest.DBCons[0].DBCon.Username. Password can also be accessed. Handy for storing in log messages.