Posts

Database profile in dellboomi

Image
 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 databa...

Dynamic Connections in dellboomi

Image
this is new feature in dellboomi this feature is available in account level ,if it is not available in your account contact your account manager Open the Connector shape, access the General tab, and check Allow dynamic connector properties.           2. Drag a Set Properties shape onto the Process Canvas, and click the plus symbol to set the properties. 3. Incorporate the Set Properties shape in the process before the Connector shape that sets the properties. In the Choose Property dialog, from the Property Type list, select Dynamic Process Connection Property.  The Connection and Field selection appears.   From the Connection list, select a connection.  From the Field list, select the field to apply the dynamic connection property.  

Embedded message: Error adding index; Caused by: The Document Cache setting allows only one entry per document in a given index.

Error:  Embedded message: Error adding index; Caused by: The Document Cache setting allows only one entry per document in a given index. Multiple document entries were produced for index:  Root cause : you will get this error if you selected Enforce one index entry per document option in document cache shape and you incoming document has multiple records. there will be confusion which record value has to take for index. Enforce one index entry per document option we will to get all document when we retrive data from document cache . Solution: Add Data Process Shape to split the document send each row as separate document. separate index will create for each row .

dell boomi usefull links

  How the Document Cache Shape Works https://community.boomi.com/s/article/how-the-document-cache-shape-works

Dell boomi interview question

1.   Whenever you are developing a soap service in dell boomi, how do you get the wsdl URL To get the WSDL URL you have to go to manage tab and then select the atom on which deployment has been done. Go to a shared server and there u will have hostname and port details.. Append /ws/soap?wsdl to it   2. Do I need to split my document up before it goes into the cache? Namely flat file and database profile need to be split up before going into the cache. Documents with multiple data rows that should recognized as separate need to be split (with a data process split) up before going into the cache or it'll be treated as one document.   3. Can I replace existing records in a document cache? There's no automatic update records with the same keys or index functionality currently. You could look up a document(s) in the cache by key and remove just that one and then add in an updated document with the same key.    4.Why is no data being returned...