Consulting Tool Kit (CTK) is a complete set of SQL Server management
tools written in Dexterity. Running inside of Dynamics GP, CTK is
easy to deploy without the special security that is sometimes needed
to access the SQL Server.
Consulting Toolkit Includes:
Database Manager
Database Manager provides inquiry-only access to server, table, view, and stored
procedure properties, and the ability to view data in SQL tables and
views.
Trace
Trace allows you to track the communication between the Dynamics GP and the database. This tool is invaluable for troubleshooting, and
identifying tables needed for reporting.
Query
Query allows you to create and run ad-hoc T-SQL queries.
You can save and run stored SQL scripts, and export
query results to Excel.
View
Wizard
View Wizard is utility for creating SQL Views of Dynamics GP tables that
using "human readable" column names. For example, instead of ITMTRKOP the column name would be ItemTrackingOption. This is a
great tool for building user-friendly tables for reporting, or for use
in complex queries creating views for SmartList Builder.
Stored Queries
Stored Queries provide the ability to create and
save tSql queries which can be securely assigned to, and executed
by, an end user.
The Stored Query can required the user to enter
parameters, and can be configured to automatically email you the
results each time the query is executed.
Stored Queries can be imported and exported for
easy transfer between clients.
Finder
Finder searches all tables in the Company
Database for any user-entered value. It locates the table,
field, and dex_row_id of the record containing the search term.
Resource Explorer
Resource Explorer searches the dexterity
definitions of the tables, windows, and reports in Dynamics GP.
Quickly locate all tables containing a particular column name, find
the product that contains a table using the SQL table name, or find
windows that use a field.
