SyteQuery Studio
Modern analytics, scripting, and cross-environment comparison for Infor Syteline ERP
What is SyteQuery Studio?
SyteQuery Studio is a specialized database analytics application designed specifically for Infor SyteLine (formerly CSI) ERP systems. It provides a modern, cloud-accessible, browser-based interface similar to SQL Server Management Studio (SSMS), optimized for analyzing SyteLine data from anywhere with an internet connection.
Unlike traditional database tools, SyteQuery Studio connects directly to SyteLine environments using the IDO (Integrated Data Object) Request Service, ensuring seamless integration with your ERP system's security and configuration. It enhances productivity with safe scripting capabilities and side-by-side stored procedure comparisons across environments for faster troubleshooting and development.
Many Infor customers moving to SyteLine in the Cloud face concerns about losing direct database visibility and control. SyteQuery Studio addresses this challenge by providing comprehensive database access whether you're on-premises or in the cloud, giving your team a clear, consistent view of data structures, business logic, and configuration changes across all environments.
Key Features
Advanced SQL Editor
Monaco-powered editor with syntax highlighting, IntelliSense, and auto-completion for SQL queries. Includes comment/uncomment functionality and SQL formatting.
Database Object Explorer
Browse tables, views, stored procedures, and functions organized by schema. Quick-select tables and views, or open definitions in new tabs without losing your work.
SyteAgent Automation
Build multi-step jobs that run on a schedule or on demand. Send results via email or webhooks with Excel, CSV, or JSON exports and keep teams in sync without manual pulls.
Scripting & Compare
Script UE_ tables with columns, keys, indexes, and triggers, then compare stored procedure definitions side-by-side to spot drift and diagnose behavior changes fast.
Query Snippets
Save frequently used queries as snippets for quick access. Organize your queries with descriptions and categories.
Multi-Environment Support
Configure and switch between multiple Syteline environments (Dev, Test, Production) with encrypted connection profiles for secure access.
Multi-Format Export
Export query results to Excel (.xlsx), CSV, or JSON formats. Perfect for reporting, data extraction, and integration workflows.
Email & Webhook Notifications
Automated email notifications with result attachments and webhook integration for scheduled jobs. Configure custom headers for API authentication.
Getting Started
Common Use Cases
Data Analysis & Reporting
Extract and analyze data from your Syteline database. Schedule automated reports to be delivered via email with Excel attachments.
Development & Testing
Test queries and stored procedures across multiple environments (Dev, Test, Prod). Save commonly used queries as snippets for quick access.
Data Integration
Extract data and send to external systems via webhooks. Integrate with reporting tools, data warehouses, and custom applications.