As the following screenshot illustrates, the DB Connection module accepts details of the server and database that is being accessed. A single Statelake configuration may have multiple DB Connections, which may all point to different servers and/or databases.

The DB Connection object class can be used to interact with the DB Connection during a mapping process, to provide 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.

Among other things, the following tasks can be achieved by working with the DB Connection object -

  • Access the property DBCon.OtherParams - this is used for storing custom configuration values. You can then access and modify these values using Source.DBCons[0].DBCon.OtherParams.Values['ParamName']

  • Retrieve the name of the database - you can determine the name of the database you are connecting to using Dest.DBCons[0].DBCon.Database. This is handy for storing in log messages.

  • Retrieve the name of the user and their password - the name of the user you are connecting to the database can be determined by using Dest.DBCons[0].DBCon.Username. The password can also be accessed. This is also handy for storing in log messages.

Declaration: Source.DBCons[0].DBCon : TFloDBCon

Dest.DBCons[0].DBCon : TFloDBCon