SQL Access Help
What can we help you with today?
Glossary | Support & Resources
SQL Access
SQL Access provides direct SQL Server database access to Sigmafine data, enabling powerful reporting, analytics, and integration with third-party business intelligence tools through standard SQL queries.
Table of Contents
Getting Started
- Introduction (4.7 SP2) - Overview of SQL Access features (version 4.7 SP2)
- Introduction (4.7) - Overview of SQL Access features (version 4.7)
- Browse All SQL Access Documents - Complete documentation index
Key Features
- Attribute Indexing - Configure indexing for improved query performance
- Auto Publication - Automate data publication to SQL Server
- Optimize Attributes to Publish - Best practices for selective attribute publication
Key Topics
Explore detailed documentation in the sidebar for:
Architecture and Requirements - System architecture, database requirements, network connectivity
Installation - Installation procedures, prerequisites, and initial configuration
Server Setup - Configure SQL Access Server, database connections, and security
Configuration Features - Publication settings, query optimization, and data refresh schedules
Publication Features - Manage data publication rules, attribute selection, and monitoring
Access Data - Query and retrieve Sigmafine data with connection methods and examples
Create TSQL Queries - Build T-SQL queries with syntax examples and performance optimization
Table Structures - SQL Server table schema reference with relationships and data types
Reports Services - Integration with SQL Server Reporting Services (SSRS)
Admin Features - User management, security configuration, and system monitoring
Navigation - User interface overview and configuration tools
Note: SQL Access enables enterprise reporting and business intelligence integration with Sigmafine data.