--- Using Direct Query ---

--- Using Stored Procedure ---

Note : For this you have to Save ODBC Driver configuration and then again reopen to configure same driver. For more information click here.

1. --- Without Parameters ---

   Now Stored Procedure can be created with or without parameters (see example below). If you use parameters then Set default value otherwise it may fail to compilation)
   
   

2. --- With Parameters ---

   Note : Here you can use Placeholder with Paramters in Stored Procedure.
   Example : SELECT * FROM $ WHERE OrderID = '<@OrderID, FUN_TRIM>' or CustId = '<@CustId>' and Total >= '<@Total>'
   

   

--- Using Virtual Table ---

Note : For this you have to Save ODBC Driver configuration and then again reopen to configure same driver. For more information click here.

ZappySys APi Drivers support flexible Query language so you can override Default Properties you configured on Data Source such as URL, Body. This way you don't have to create multiple Data Sources if you like to read data from multiple EndPoints. However not every application support supplying custom SQL to driver so you can only select Table from list returned from driver.

Many applications like MS Access, Informatica Designer wont give you option to specify custom SQL when you import Objects. In such case Virtual Table is very useful. You can create many Virtual Tables on the same Data Source (e.g. If you have 50 Folders with slight variations you can create virtual tables with just URL as Parameter setting).

vt__Customers
DataPath=myFolder_1/customers.csv

vt__Orders
DataPath=myFolder_2/orders.csv

vt__Products
DataPath=myFolder_3/products.csv

1. Click on the Custom Objects Tab, Click on Add button and select Add Table and Enter an appropriate name and Click on OK button to create.
   
2. Once you see Query Builder Window on screen Configure it.
   
3. Click on Preview Tab, Select Virtual Table(prefix with vt__) from Tables Dropdown or write SQL query with Virtual Table name and click Preview.