How to query data from MYSQL using stored Procedure
When I normally integrate database with Salesforce using Dell Boomi i use views to query data from database, but due to some complex query structure not supported by MYSQL we ended by changing our approach and start querying data from a stored procedure.
Dell Boomi support querying data via a stored procedure, but there is a well known error you may face when try this feature.Before going towards error i first let you know how to get data using a stored procedure.
We have to create a "Get" database operation then create a database profile.In the "Type" fields select "Stored Procedure" rather than query.
Then import profile using stored procedure name from your database.When import profiles completed you wont be able to see any child elements in profile. You have to manually create all elements in profiles and then map.
This is it....
Now come to error part when you will try to run this process you might face an error saying "stored procedure not found". This is Dell Boomi known error. What happen is that when you import stored procedure from your database boomi automaically append database name with stored procedure name and when try to run it gives error.
Please remove the schema-Name from the Stored Procedure name in the Database profile after Importing. For example, after you import the Stored Procedure, please change the name from 'OLTP_Symitar.IRA_ScoreCard' to 'IRA_ScoreCard' and Save the profile.
Error Solved :)
