Data Provider Command packages in Exmon

In this article you will learn what Data Provider Command packages are and how you can use them

Data Provider Command package in Exmon allows users to execute predefined scripts(i.e. stored procedures) or custom scripts against Data Providers in Exmon.

To create a Data Provider Command:

1. Open ExmonDG Desktop
2. Right-click "Packages" in the Object Explorer
3. Select "New" and "Data Provider Command"
   
4. Give your Data Provider Command a name
5. Select a Execution Connection that you'd like to execute your package on
   1. Some Data Providers are only accessible on certain servers and therefor you need to select the correct server to execute the package on
6. Select a Data Provider that you'd like to execute your script against
   1. If your Data Provider does not exist you can create it under General -> Data Providers
   2. NOTE: Currently Data Provider Command can only execute against SQL servers
7. Now you can select your predefined script or check the Custom Script checkbox to create a custom script
   1. NOTE: If your predefined script uses parameters you can fill them in using static data or use package parameters