TracerPlus and TracerPlus Connect gives you flexibility in the database types you can sync with. This also applies to the objects within that database. Most people know that you can sync with database Tables, however it is also possible to use Views, and Stored Procedures.
If the database you are using supports it, Stored Procedures will show up in the Table drop down of your TracerPlus Connect Configuration. They can be selected in the same way as Tables. Immediately after choosing a Stored Procedure the Field Mappings grid will be populated with the parameters of that stored procedure. Usually when this happens the return value will show up as the first field. This should be removed from the mappings as it cannot be used in your Sync Process. All other parameters should then be mapped to their appropriate Fields within the Field Mappings grid.
When using stored procedures there are a few things that you need to keep in mind. The most important is that Stored Procedures are only usable as a Destination of your data and in a Sync Profile. This means that data cannot be retrieved from the stored procedure, but the stored procedure can be run with the values coming from your Source in the Sync Process.
Comments
0 comments
Please sign in to leave a comment.