Database profile in dellboomi

 Database profile represents set of data to be write or read from Database.

We have two type of Database Profiles.

  We can select Read or Write profile in option tab Execution type in profile.

• Read profiles : Read profiles are used to read the data from database. and these profiles  we use in source part in map shape to transfer data retrieved from database to next shape.

           this profile contain 3 parts.

                    Statement : there are two types of statements 

                                             SQL : Select Query

                                              Stored Procedure Read : stored procedure which return data from database

 

                      Fields :  database columns returned from sql statement or stored procedure

                      Parameters : where clause parameters in sql statement

  

               we can auto-generates a SQL statement, profile fields, and parameters based on the tables and columns                  that you select by using import option .

               import option is enabled when we select the statement 

                  

• Write profiles : Write profiles are used to send data to database . and these profiles  we use in destination part in map shape to map data to send to database.

                    this profile contain 2 parts.

                    Statement : there are 5 types of statements 

                                        Standard insert/update/delete 

                                        Dynamic Insert

                                        Dynamic Update

                                        Dynamic Delete

                                        Stored Procedure Write : stored procedure which write data from database

                                           

                      Fields :  database columns to send data to sql statements or stored procedure

            in write profile Import option is enabled only for 

                                    Dynamic Insert

                                        Dynamic Update

                                        Dynamic Delete

                                        Stored Procedure Write

Import wizard 

       when you click on Import button. it will open new window with Database Import Wizard .

        

           Browse In : select from where you select the connection.

           Connection : from which data base connection you will select the tables.

           Schema Filter : we can use wildcard search using *  with an alphanumeric string to reduce the number of                                              schema returned.

           Object Filter : we can use wildcard search using *  with an alphanumeric string to reduce the number of                                              tables returned.

         click on next  ,list of tables will come.

 

Select table and click on next. based on type you selected next window will change , for few it will show list of columns , for few list of attributes for condition .

Select the list of columns and click on next . finish window will open.

after clicking on finish ,SQL statement and fields will be auto populated in database profile.