Contact UsContact Us

Direct SQL Access

xRM can provide designated individuals inside your organization with direct access to your SQL servers.

Keep your SQL servers running at peak performance

All private cloud plans include at least one dedicated Microsoft SQL Server database instance, and xRM ensures the right people have access to do the following:

  • Employ traditional and legacy ETL tools and direct SQL reads
  • Read data from CRM using the supported SQL Filtered Views instead of the slower web based API/FetchXML for workflow assemblies, plugins, reports, etc.
  • Closely control backup and retention policy so data backups are much more manageable, comprehensive, and more easily portable
  • Move data to a different provider and on-premises server multiple times via simple backup/restore function (movement to CRM Online will require data migration)
  • Use custom SQL objects -- databases, tables, views, and stored procedures are allowed via additional custom SQL databases that reside alongside the CRM database in the same SQL instance
  • Restore foreign data stores for the purposes of data warehousing, data migration, etc. for vastly superior response times compared with traditional cloud solutions
  • Monitor performance of items like custom code executions, including workflows and plugins

Sideimg-Direct-sql-access

For more information on granting certain individuals access to your SQL servers, give us a call. Or, submit our simple form to arrange an in-depth consultation.







  • This field is for validation purposes and should be left unchanged.