skills.rest
NCLGISA
NCLGISAOFFICIAL
Explore all skills by this author →
WebsiteGitHub

munis-odbc

Query Tyler Munis ERP SQL Server data via ODBC Driver 18.

Updated Aug 23, 2026
Search Tags:#finance#erp#payroll#sql server#odbc#tyler#munis
One-click install
npx skills add https://github.com/NCLGISA/trellis-catalog --skill munis-odbc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: munis-odbc
Source: https://github.com/NCLGISA/trellis-catalog/tree/main/bridges/munis/skills/munis-odbc
Command: npx skills add https://github.com/NCLGISA/trellis-catalog --skill munis-odbc

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides secure, read-only access to the Tyler Munis ERP SQL Server database, enabling financial reporting, budget analysis, and payroll data retrieval without direct database administration.

Core Features & Use Cases

  • Query Reporting Functions: Access pre-defined table-valued functions for GL, Payroll, AP, and other modules.
  • Ad-hoc Queries: Run custom SQL SELECT statements against reporting views.
  • Pre-built Reports: Utilize templates for common reports like GL detail, budget vs. actual, and employee lists.
  • Use Case: Generate a report of all active employees with their primary department and hire date by running the employee_list report.

Quick Start

Use the munis-odbc skill to run a query for the top 50 GL journal entries for fiscal year 2026.

Frequently Asked Questions about munis-odbc

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Tyler Munis ERP financial data using SQL Server?▼

Query Tyler Munis ERP financial data using SQL Server by connecting via read-only ODBC access with Microsoft ODBC Driver 18 and TLS encryption. This enables you to run ad-hoc SELECT statements against reporting views and table-valued functions for GL, AP, and Payroll modules.

What's the best way to generate payroll reports from a Tyler Munis cloud instance?▼

Generate payroll reports from a Tyler Munis cloud instance by using pre-built report templates like employee lists or by querying table-valued functions. Access is secured through a site-to-site VPN connection to the Tyler-hosted SQL Server database.

Can I run ad-hoc SELECT statements against Tyler Munis reporting views?▼

Yes, you can run ad-hoc SELECT statements against Tyler Munis reporting views. The ODBC connection supports custom SQL queries, allowing you to retrieve specific financial and payroll data beyond the provided pre-built report templates.

Does the Munis ODBC connection support write access to modify ERP records?▼

No, the Munis ODBC connection is strictly read-only. It is designed for financial reporting, budget analysis, and payroll data retrieval, preventing any direct database administration or modification of the underlying Tyler Munis ERP records.

Do I need a site-to-site VPN to access Tyler Munis ERP data?▼

Yes, a site-to-site VPN is required to access the Tyler-hosted cloud instance. This secure connection works in tandem with Microsoft ODBC Driver 18 and TLS encryption to protect your SQL Server data during financial and payroll queries.

Related Skills

Explore More Finance & Accounting Skills→
BagelHoleBagelHole
46

vpn-setup

Configure WireGuard, OpenVPN, and AWS Site-to-Site VPN tunnels.

Community
Intermediate
kevinlinkevinlin
14

reconciliation

Compare GL totals to subledgers and bank statements to identify discrepancies.

Community
Advanced
DavidsonGomesDavidsonGomes

fin-variance-analysis

Decompose actual versus budget variances into volume, price, mix, and other drivers.

Community
Advanced
MindOpsTeamMindOpsTeam

bling

Integrate Bling ERP data via REST API with OAuth 2.0.

Official
Advanced