Home Services Partners Company

DataDirect Cloud: Accessing Eloqua data with a linked server in Microsoft SQL Server

August 30, 2016

DataDirect Cloud provides simple, secure access to cloud and on-premises data sources for your business intelligence tools and applications. Using DataDirect Cloud, you can securely expose Eloqua data to a variety of consuming applications, even databases like Microsoft SQL Server. The linked server functionality within Microsoft SQL Server is useful, for example, to run queries that join tables from Eloqua with those in a SQL Server instance. This video demonstrates how to configure a linked server to consume Eloqua data. You would use a similar configuration to access other data sources exposed by DataDirect Cloud.

Tags: server SQL Microsoft Eloqua DataDirect Cloud Data Sources Microsoft SQL Server MySQL How To