I am new to boomi. i am trying to import data from salesforce to a mysql db, however when I import, i need to automatically create a unique id (not the sf id) in the mysql db. Is there a way to do this?
In your map, add a map function --> Properties --> Get Document Property --> click OK --> Click on Search --> Select Dynamic Document Property under Property Type --> Type Property Name as UniqueID --> Click OK OK.
Then map this to your destination DB profile element.
Hope this helps.
For each record you can generate Unique key using set properties shape
Initialize this set properties step right after SFDC get.
Now get this Dynamic Document Property in Map shape when you are sending data to DB.
This looks like what I am looking to do. What I am unsure of is how to map this so that it creates an output that goes into my DB field. Here is what my process looks like
Not sure if this is right so far. Still do not understand the mapping portion. Any help is greatly appreciated.
Perfect. It is working now. One issue i am having is taht the process creates duplicate record entries now when I run it. The records have unique IDs, however everything else is duplicate. I though setting the enforce unique option would fix this but it does not. Any ideas?
Where did you set Enforce Unique option? Generally Enforce Unique is associated with Flat file profile?
Are you using Flat file profile in your map? Can you provide a screenshot?
The important point to remember is that the Flat file profile (defined with Enforce Unique) should be at the destination side. If that is not the case, create an extra map with both source and destination as same Flat file profiles with 1-to-1 mappings for all fields.
ahh. I tried setting it in the profile. I am not using a flat file. See screen shot.
I tried making a decision tree where if first value(mg XML sf query select specific field) is equal to second value (database profile mysql query select specific field), true, then stop, if falese, then do the mapping and import. does not seem to work, still imports duplicates.
Hi Mike Daniels,
I think Hari was asking about a screenshot of your map to see what fields you have mapped. When you say "duplicate", what exactly are you observing? It looks like your syncing Opportunities to Customers? I could imagine if you picked up multiple Opportunities that happened to be for the same Account and only mapped the Account-related fields, those could appear as "duplicates" but with different "UniqueID" property values because those were set per Opportunity document...
Thanks for the reply. The behavior I am seeing is when I run the process the 1st time it gives me the records and inserts them into the db with a unique id. If i run it again, it inserts the exact same record with a different unique id. I am trying to make it not insert the record of the oppid already exists in the db.
You have to do sql lookup before this map to check whether oppID already exists in the database.
You can use Decision Shape --> Sql Statement for this.
Hi Mike Daniels, why don't you set the opportunity Id column in your SQL db set to Unique. Also, do you specifically want to pick up the opportunities from SFDC a second time? It sounds like you might need to go back and update the Opportunity in SFDC as 'Processed'. In your SFDC Query filter out the processed records.
You can add a function (Get Document property-> Dynamic Document property) into your map to get the unique value which is saved in Set property step. Hope this helps.
This is also useful can you try this one.
Set this property before map shape and get set properties in map shape and then map unique field.
Retrieving data ...