Database profiles represent the data set to be retrieved from or written to a relational database. Data sets contain the SQL code used to select, insert, update, or delete records. A given profile is paired with a specific database connector operation
refer the below link
http://help.boomi.com/atomsphere/GUID-B15E86E2-A76A-435E-A3F5-F810075192F8.html