ProClarity on Win 7 64-bits

From DataSelf Knowledge Base
Revision as of 17:30, 15 September 2014 by Dataself (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

ProClarity installation tips:

Windows 7 ProClarity Installation

In the ProClarity63 installation folder:
Run the Setup.exe file in the following folder:

Service Pack 3

make a folder to unzip it to, and Browse to that folder when it asks to unzip.

Needs OLAP services for SQL 2000

“Microsoft Pivot Table Services for SQL Server 20000 SP4 or greater was not properly intalled.”

Go to “.6x\Desktop Install\install\PTS\EN”, and run ptslite.exe

64-bit machines

On a computer with Win 7 64-bits, install the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider from the page below to be able to install ProClarity 6.3.

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

The Analysis Services 9.0 OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2005 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.

Note: Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0 available at:

Audience(s): Customer, Partner, Developer

X86 Package (SQLServer2005_ASOLEDB9.msi)
X64 Package (SQLServer2005_ASOLEDB9_x64.msi)

No desktop shortcut

You will want to say NO to shortcut on desktop, and instead make a shortcut to the bbk file shared on the server.

Remote access Over VPN or RDP

Note that you do not want to be saving changes to the bbk file over a VPN – we have seen that be not stable enough, and the whole bbk gets corrupted and has to be restored from backup. You can, though save a copy of the bbk to your laptop desktop and use that.

But if you are on an RDP or a Citrix session, it is OK to save changes to the bbk, since the bbk is actually on the server’s session - it is not traveling across a VPN.