I have discussed in previous articles how Sage CRM has the ability to link to external databases.  Once an external database table is linked to Sage CRM the data in the table can be made available within the Interactive Dashboard.

Another benefit of changing the External Access of the linked table to allow SData access is that this table will be available to the SData schema and so available to any third party application.

The article below discussed how to make the Suppliers table of the Northwind database available as an SData source.

Making an External Table Available as an SData Gadget in the Interactive Dashboard

If we use the Suppliers table as an example, once SData access has been confirmed you can access the Supplier information with RESTful SData requests.

These requests all follow the standard URL that are described in the documentation.  

e.g.

  • http://[servname]/sdata/[installname]j/sagecrm/-/suppliers/$schema
  • http://[servname]/sdata/[installname]j/sagecrm/-/suppliers
  • http://[servname]/sdata/[installname]j/sagecrm/-/suppliers(supplierid eq '3')

Note:  You will have to handle security when accessing the SData provider.  Please see the article:  Security and the SData Gadget and ReadOnly SData provider.  

An external application can then make a request to Sage CRM for data that actually exists in another database.

e.g.

http://myserver/sdata/crmdppj/sagecrm/-/suppliers(supplierid eq '3')

Sage CRM will then return the XML


<?xml version="1.0" encoding="UTF-8"?><entry xmlns="http://www.w3.org/2005/Atom" xmlns:http="http://schemas.sage.com/sdata/http/2008/1" xmlns:sdata="http://schemas.sage.com/sdata/2008/1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <id>http://richardsj-lt/sdata/crmdppj/sagecrm/-/suppliers(supplierid eq '3')</id>
  <title>Suppliers</title>
  <link href="http://richardsj-lt/sdata/crmdppj/sagecrm/-/suppliers(supplierid eq '3');jsessionid=12DB164392BA2E94C6CA87E726967CD3" rel="self" title="Refresh" type="application/atom+xml; type=entry;charset=UTF-8"/><link href="http://richardsj-lt/sdata/crmdppj/sagecrm/-/suppliers/$schema;jsessionid=12DB164392BA2E94C6CA87E726967CD3" rel="http://schemas.sage.com/sdata/link-relations/schema" title="Schema" type="application/xml;charset=UTF-8"/><link href="http://richardsj-lt/sdata/crmdppj/sagecrm/-/suppliers;jsessionid=12DB164392BA2E94C6CA87E726967CD3" rel="http://schemas.sage.com/sdata/link-relations/post" title="Post" type="application/atom+xml; type=entry;charset=UTF-8"/><updated>2010-10-28T12:36:14+01:00</updated>
<content/> 
  <sdata:payload><suppliers sdata:key="3" sdata:url="http://richardsj-lt/sdata/crmdppj/sagecrm/-/suppliers('3');jsessionid=12DB164392BA2E94C6CA87E726967CD3" xmlns:tns="http://schemas.sage.com/scrm">
<phone>(313) 555-5735</phone>
<postalcode>48104</postalcode>
<contacttitle>Sales Representative</contacttitle>
<companyname>Grandma Kelly's Homestead</companyname>
<address>707 Oxford Rd.</address><city>Ann Arbor</city>
<contactname>Regina Murphy</contactname>
<homepage xsi:nil="true"/>
<fax>(313) 555-3349</fax>
<supplierid>3</supplierid>
</suppliers></sdata:payload>
</entry>