The SQL Writer Tool

WebLink Connect runs on SQL, a powerful and flexible database structure that makes organizing and retrieving data very easy. For some users, the Stock Report Library and the Data Export & Reporting Tool are more than enough to extract and analyze data from WebLink. For more advanced users, the SQL Writer Tool allows you to generate your own SQL Queries and run them against your own data.

Follow these steps to use the SQL Writer Tool:

  1. Go to Reports > SQL Writer Tool. The SQL Writer Tool window will open.
  2. Enter your SQL Query in the text box under Enter your SQL Query here.
  3. Click Run Query. If your SQL was written correctly and generated result, the Results Data Grid will populate with information. If your SQL Query was written incorrectly, you will receive an Error Message.

Best Practices in Using the SQL Query Tool

  1. If you think you will use the same SQL Query multiple times, save it as an HTML Template. By doing this, it will be available in the right-click menu when you click in the top text area. Click here to learn how to create an HTML Template.
  2. You can learn about SQL by attending a WebLink Level 4 Certification class. Click here to learn about WebLink Certification.

 

----------------------------------------------------------------------------------------------

 This feature is included or available for purchase with the following WebLink Connect packages.

 

Comments

0 comments
Want some training on WebLink Connect? Sign up today for one of our upcoming online training classes.