FAQs for SQL Reporting Solutions

How is the ETL triggered?

By default, the Autosumm component is responsible for scheduling and triggering the ETL. When running Setup, an Autosumm job is created that runs every 15 minutes. In a single-server deployment, this job will directly trigger the SSIS packages using the dtexec utility. In a multi-server deployment, the job will connect to the SSIS Server and trigger the SQL Agent job that runs the ETL.

Is AlwaysOn (HighAvailability) supported in SQL Reporting Solutions?

Yes, it is. Please provide the AlwaysON Group Listener IP Address to Setup when prompted for the SQL Server/SSIS Server hostname.

Is there a required default collation setting for the two databases?

Yes, Latin1_General_CI_AS.

Provide feedback on this article