We are installing the latest Microsoft CRM version and we want to build reports on the database (msSQL 2005) Has anybody done this before, is there somewhere information available on that database structure?
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
December 28, 2006, 09:13 AM
RichH
Hi Frank, You might want to ask this under the iWay section and find out if theres an adaptor available. Rich
WebFOCUS 8202 Win 2012 Test - WebFOCUS 8203 on Win 2012
December 28, 2006, 09:31 AM
FrankDutch
I think there is an adapter, but I will try to build my own reports instead of using the predefined reports from Bill, and I want to combine that info with transaction based info from other databases.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
April 12, 2007, 02:56 PM
valixx
Connect from webfocus with CRM MSSQL2005 database using MS SQL Server adapter and find the right adapter to connect with " other databases" , add new synonyms and build your reports. To see more easy the tables from CRM install SQL Server Management Studio Express is free.
Regards, ValixxThis message has been edited. Last edited by: valixx,
April 12, 2007, 04:03 PM
Francis Mariani
Valixx,
Thanks for the info on SQL Server Management Studio Express. Do you know if it can access SQL Server 2000 databases?
Regards.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 12, 2007, 04:17 PM
valixx
You can use SQL Server Management Studio Express to connect just with SQL 2005 versions .
vali
April 12, 2007, 04:24 PM
valixx
Francis , For connect with SQL 2000 use SQL Server Web Data Administrator .