In boomi if you want to run an INSERT/UPDATE/QUERY operation in a connector shape you probably will need to use a ‘?’ as a dynamic parameter. In figure 1 we can see that the number of ‘?’ is exactly the same as the number of the fields (highlighted in blue). In this situation the SQL statetment will work without any error.
If we need to use both dynamic and static parameters at the same time, and we use the same technique as above, with a static parameter, we get the following:
This will result in the error “First document failure: Invalid column index” :
The solution is to remove the static ‘CREATED_TAD’ field from the parameter but leave it in the SQL statement:
Today Dell Boomi released a great new feature – Document Cache.
You can configure a cache on any profile (say a Flat File of all your accounts). You can read in that file in one branch and map it to the cache, and set a key, say account ID.
If for example, you have a process that reads an order from a database or an app such as salesforce.com, you can, in the map step where you are mapping that, add the Cached Data, choose which field in the Order profile to link to the Key in the Cache (Account ID) and it will bring in that profile into the source map. You can then map directly from any of the Order, or matched Account profiles to your target.
Dell Boomi has just launched a certification program for their partners. If you’re asking yourself is this an attempt at shameless self promotion, you’re right, WDCi is one of the first certified partners. Boomi announced the list of initial certified partners in their Spring Product Release announcement.
Details on the certification program can be found here: http://help.boomi.com/display/BOD/AtomSphere+Certification+Program.