sql server connection string server vs data source

For an introductory article that explains how data can be pulled from Sage CRM and consumed by another application such as a Sage ERP package then please see ' SData Provider introduction'. Note: The adoption of SData as a communication mechanism between different Sage products will allow Sage CRM and Sage ERP packages to exchange their data as very efficient HTTP requests and responses. The physical link between the Sage CRM SQL Server and the remote Sage ERP MAS data might be slow. When absolute, best possible performance is required, local data will out perform a linked server. And without being able to define a view we can't create groups or reports.Ī linked server provides us with more options. NET assemblies to access the data.īUT it doesn't provide a way of defining a view that straddles the two data sources. Meta Data definitions can be stored that allow screens and lists to be used in ASP and. The data connection allows the ERP data to be accessed easily using the Sage CRM API objects. Sage ERP MAS 90', I discussed how a connection can be defined in Sage CRM to the Sage ERP MAS database and individual tables. In my previous article ' Connecting to an External ODBC database e.g. So creating on-demand access to realtime data is part of the tool set that a Sage CRM developer needs. However, duplicating data on both the ERP and CRM servers is not always the best solution and the challenge for any developer, since large amounts of data could be moved 'just in case', is to predict what subset of data a customer may need. The Sage ERP MAS 90 Extended Enterpise Suite moves data from Sage ERP MAS 90 to Sage CRM relatively easily. See the article ' Integration with External Systems and the Synchronization of Application Data'. Within an integration some data may be synchronized. With a linked server, you can define very simple views that allow data from an ERP system like Sage ERP MAS 90 to be retrieved, joined and combined with Sage CRM Data. If you have a background of using Access then you can think of a Linked Server as similar to the MS Access feature of a 'Link Table.'īut why do I want to use this in Sage CRM? This external data source can be in another RDBMS like Oracle or almost any other data system that can be accessed by OLE or ODBC-including Sage ERP MAS 90. A Linked Server within MS SQL Server is type of 'alias' within the SQL server that points to an external data source rather than a SQL Server database.

Sql server connection string server vs data source