You are here: Home Administration Reports Creating Ad Hoc Connections for SACWIS Reporting
 

Most Read Administration Articles

Latest Administration Articles

Creating Ad Hoc Connections for SACWIS Reporting

  • Print
Details
Category: Reports
Published on Tuesday, 14 February 2012 20:26
Hits: 1270
Attachments:
Download this file (Linking from SQL Server.pdf)Linking from SQL Server.pdf[ ]610 Kb
Download this file (Reporting_overview_2012.pdf)SACWIS Reporting Overview[ ]1292 Kb
Download this file (SACWIS Ad-Hoc Connectivity Summary.pdf)SACWIS Ad-Hoc Connectivity Summary.pdf[ ]148 Kb
Download this file (SACWIS Crystal Reports.pdf)SACWIS Crystal Reports.pdf[ ]905 Kb
View Comments

 

Review the attached documents for information on setting up a connection to the Ad Hoc database and Crystal Reports for reports.

  • SACWIS Ad-Hoc Connectivity Summary - Provides a summary of the procedural and technical steps required for Counties to access the SACWIS Ad-Hoc and Near Real-Time Replicated Databases and the Production Database.
  • SACWIS Crystal Reports - Describes how to set up Crystal Reports XI to generate reports using SACWIS Ad-Hoc data, and how to use the connection you create to view data 
  • Linking from SQL Server - Describes how to install an Oracle client on your SQL Server machine, and link to SACWIS database instances to create report queries in SQL Server.
  • Reporting Overview - SACWIS Reporting Overview presentation.