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 - Overview of SQL Access features and capabilities (version 4.7 SP2)
• Introduction (4.7) - Overview of SQL Access features (version 4.7)

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

Architecture and Setup

• Architecture and Requirements - System architecture and technical requirements

  • Server architecture overview
  • Database requirements
  • Network and connectivity
  • Performance considerations

• Installation - Install and configure SQL Access

  • Installation procedures
  • Prerequisites and dependencies
  • Initial configuration
  • Verification steps

• Server Setup - Configure SQL Access Server

  • Server configuration
  • Database connection setup
  • Service configuration
  • Security settings

Configuration

• Configuration Features - Configure SQL Access options

  • Publication settings
  • Query optimization
  • Data refresh schedules
  • Connection parameters

• Publication Features - Manage data publication

  • Publication rules
  • Attribute selection
  • Publication scheduling
  • Monitoring and validation

Working with Data

• Access Data - Query and retrieve Sigmafine data

  • Connection methods
  • Query examples
  • Data access patterns
  • Integration approaches

• Create TSQL Queries - Build T-SQL queries for Sigmafine data

  • Query syntax and examples
  • Join operations
  • Aggregation and filtering
  • Performance optimization

• Table Structures - SQL Server table schema reference

  • Published table structures
  • Column definitions
  • Relationships and keys
  • Data types and formats

Reporting

• Reports Services - Integration with SQL Server Reporting Services (SSRS)
  • Report design
  • Data source configuration
  • Report examples
  • Deployment and scheduling

Administration

• Admin Features - Administrative tools and functions

  • User management
  • Security configuration
  • System monitoring
  • Maintenance tasks

• Navigation - Navigate SQL Access interface

  • User interface overview
  • Tools and utilities
  • Configuration dialogs
  • Help and resources

---

Note: Comprehensive documentation for each topic is available in the sidebar navigation.