Start a conversation

Using Database Stored Procedures with TracerPlus

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.

Choose files or drag and drop files
Was this article helpful?
  1. Howard Heckman III

  2. Posted
  3. Updated