1 / 23

Installation and Configuration

Installation and Configuration. Presenter: Anthony Vieira. Agenda. SYSPRO Analytic installs Service Packs Pitfalls to watch out for SQL Server 2005 Configuring SYSPRO Analytics. SYSPRO Analytic Installs. SYSPRO Analytics Network install SYSPRO Analytics Client install

miyo
Download Presentation

Installation and Configuration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Installation and Configuration Presenter: Anthony Vieira

  2. Agenda • SYSPRO Analytic installs • Service Packs • Pitfalls to watch out for • SQL Server 2005 • Configuring SYSPRO Analytics

  3. SYSPRO Analytic Installs • SYSPRO Analytics Network install • SYSPRO Analytics Client install • SYSPRO Analytics enet service install

  4. Network Install • Issue 9 – 3 installs • Standalone • Server • Client • Issue 10 Network install = • Standalone + Server + Client • Network install must be installed on a machine that has SQL Server and Analysis Services

  5. Network Install • A network installation loads all the server and client components that comprise the SYSPRO Analytics Framework • You implement a network installation when the machine on which you are installing SYSPRO Analytics functions as both the Analytics server and Analytics client

  6. Network requirements • .NET Framework • Analysis Services – 2000 or 2005 • Service packs 3/4 (Analysis Services 2000) • SQL Server – 2000 or 2005 • Service packs 3/4 (SQL Server 2000) • OWC Components (OWC11) • Common Folders check • OWC10 doesn’t support SQL 2005

  7. Client Install • Primarily SYSPRO Analytics viewer • Limited Administrator functionality • Note • If machine has SQL Server and Analysis Services load the Network install • Network instances can integrate and act as clients with other network installs

  8. Client Install • NET Framework • Client components • Connections to SQL Server and Analysis Services • Folder SYSPROAnalyticsClientReq on issue 10 CD • Setup.exe

  9. Enet service installation • The e.net service installation installs components to provide integration into SYSPRO e.net architecture • Installed on SYSPRO application server • Only installed if the SQL Server and SYSPRO Application server are different • Integration used for • Company License information • Language Translation

  10. Supported Service Packs • SQL Server • Service Pack 3/3A (Sql2ksp3.exe) • Service Pack 4 (Sql2ksp4.exe) • SQL Server Analysis Services • Service Pack 3/3A (Sql2ksp3a.exe) • Service Pack 4 (Sql2ksp4a.exe)

  11. SQL 2005 • Two Beta sites at the moment • What to look out for • SQL Server Integration Services must be installed • SQL Server Analysis Services must be installed • Possible to run SQL Server 2005 and Analysis Services 2000

  12. Pitfalls to watch out for • Do not install both the Network and client installs on the same machine. • Client components files will get overwritten • In the event of doing this – reapply the service packs. • Network can function as a viewer as well, so if a machine has SQL and you wish to load Analytics – load the Network install.

  13. Configuring SYSPRO Analytics • SYSPRO Company integration • SYSPRO Setup • Licensed for Analytics • Operator “__SA” • Default company • ADMIN group • E.net installed

  14. Licensing for SYSPRO Analytics

  15. System Configuration

  16. Operator ‘__SA’

  17. SYSPRO Analytics Companies

  18. KPI/Metrics

  19. Build Metrics – Build Options

  20. Build Metrics – Integration Service Packages

  21. Build Metrics – Analysis Services

  22. Build Process • Builds DTS packages to transform data into information • Creates an OLAP structure to read this information • Creates a default schedule to run once using the SQL Server Agent

More Related