Access to MS CRM data by non-licensed users

What is the best way for a non-licensed user to access MS CRM data?

Has anyone from Microsoft ever stated that you can access the MS CRM
SQL database directly with a SELECT statement and not break the
licence agreement?

Can anyone copy the MS CRM data into another database and access that
data without a license?

Can anyone use the MS CRM filtered views to either access the MS CRM
database directly or to make copies of the data?

Has anyone written an MS CRM add-on application that pass the
certification test which directly reads MS CRM data?

If the MS CRM license is only for the software, then all of the above
except for the filtered views should be ok.

RonaldL
Thu May 10 12:05:01 CDT 2007

Hi Richie,

I have had several discussions with microsoft about how to access data.
Based on these discussions I can tell that accessing the database directly is
not allowed and accessing the filtered views is allowed for reporting. But
when you access the filtered views, you need a license. What you can do, is
automatically create a report and place this report available for others to
download. Doing this is allowed as long as you the schedule is set to 24
hours or longer.

Hope this helps,
--
Ronald Lemmen - MSCRM MVP
Avanade Netherlands
http://www.ronaldlemmen.com/


"richie.moore@richie-moore.com" wrote:

> What is the best way for a non-licensed user to access MS CRM data?
>
> Has anyone from Microsoft ever stated that you can access the MS CRM
> SQL database directly with a SELECT statement and not break the
> licence agreement?
>
> Can anyone copy the MS CRM data into another database and access that
> data without a license?
>
> Can anyone use the MS CRM filtered views to either access the MS CRM
> database directly or to make copies of the data?
>
> Has anyone written an MS CRM add-on application that pass the
> certification test which directly reads MS CRM data?
>
> If the MS CRM license is only for the software, then all of the above
> except for the filtered views should be ok.
>
>

plus_nospam_petra
Thu Jun 14 06:42:00 CDT 2007

What I heard recently is that MS is introducing a new type of license which
is a client for Office or Sharepoint, where these "users" can access certain
data or reports from Office or Sharepoint, without a "proper" license. I
believe those prices where something like â?¬ 130 for Office and some more for
Sharepoint.
Anyway, I don't know the specifics, but your Partner should know more soon.


"richie.moore@richie-moore.com" wrote:

> What is the best way for a non-licensed user to access MS CRM data?
>
> Has anyone from Microsoft ever stated that you can access the MS CRM
> SQL database directly with a SELECT statement and not break the
> licence agreement?
>
> Can anyone copy the MS CRM data into another database and access that
> data without a license?
>
> Can anyone use the MS CRM filtered views to either access the MS CRM
> database directly or to make copies of the data?
>
> Has anyone written an MS CRM add-on application that pass the
> certification test which directly reads MS CRM data?
>
> If the MS CRM license is only for the software, then all of the above
> except for the filtered views should be ok.
>
>

RonaldL
Fri Jun 15 09:57:00 CDT 2007

Hi Petra,

Do you have more information about this? I haven't heard about it before and
am very interested if this is indeed true.

Ronald
--
Ronald Lemmen - MSCRM MVP
Avanade Netherlands
http://www.ronaldlemmen.com/


"petra" wrote:

> What I heard recently is that MS is introducing a new type of license which
> is a client for Office or Sharepoint, where these "users" can access certain
> data or reports from Office or Sharepoint, without a "proper" license. I
> believe those prices where something like â?¬ 130 for Office and some more for
> Sharepoint.
> Anyway, I don't know the specifics, but your Partner should know more soon.
>
>
> "richie.moore@richie-moore.com" wrote:
>
> > What is the best way for a non-licensed user to access MS CRM data?
> >
> > Has anyone from Microsoft ever stated that you can access the MS CRM
> > SQL database directly with a SELECT statement and not break the
> > licence agreement?
> >
> > Can anyone copy the MS CRM data into another database and access that
> > data without a license?
> >
> > Can anyone use the MS CRM filtered views to either access the MS CRM
> > database directly or to make copies of the data?
> >
> > Has anyone written an MS CRM add-on application that pass the
> > certification test which directly reads MS CRM data?
> >
> > If the MS CRM license is only for the software, then all of the above
> > except for the filtered views should be ok.
> >
> >

plus_nospam_petra
Mon Jun 18 04:11:00 CDT 2007

Well, the only thing I remember is that Heleen van Offenbeek (Business Group
Manager MS Business Applications) mentioned this on the User Event last June
6, and it was called "Microsoft Dynamics Client for Office/Sharepoint"
Sorry I don't have more...

Wat zitten hier trouwens veel Nederlanders! :)

petra


"Ronald Lemmen" wrote:

> Hi Petra,
>
> Do you have more information about this? I haven't heard about it before and
> am very interested if this is indeed true.
>
> Ronald
> --
> Ronald Lemmen - MSCRM MVP
> Avanade Netherlands
> http://www.ronaldlemmen.com/
>
>
> "petra" wrote:
>
> > What I heard recently is that MS is introducing a new type of license which
> > is a client for Office or Sharepoint, where these "users" can access certain
> > data or reports from Office or Sharepoint, without a "proper" license. I
> > believe those prices where something like â?¬ 130 for Office and some more for
> > Sharepoint.
> > Anyway, I don't know the specifics, but your Partner should know more soon.
> >
> >
> > "richie.moore@richie-moore.com" wrote:
> >
> > > What is the best way for a non-licensed user to access MS CRM data?
> > >
> > > Has anyone from Microsoft ever stated that you can access the MS CRM
> > > SQL database directly with a SELECT statement and not break the
> > > licence agreement?
> > >
> > > Can anyone copy the MS CRM data into another database and access that
> > > data without a license?
> > >
> > > Can anyone use the MS CRM filtered views to either access the MS CRM
> > > database directly or to make copies of the data?
> > >
> > > Has anyone written an MS CRM add-on application that pass the
> > > certification test which directly reads MS CRM data?
> > >
> > > If the MS CRM license is only for the software, then all of the above
> > > except for the filtered views should be ok.
> > >
> > >