Pulling in all your cloud data sources to SQL server is easy as 1-2-3 with Link Server and DataDirect Cloud connectivity.
People use linked servers all the time. When you use SQL server, a linked server is a powerful tool to bring today’s increasing number of external data sources into your SQL server.
This tutorial shows you specifically how to easily pull cloud data into your SQL server using Linked Server and Progress® DataDirect Cloud®. This includes HubSpot, Marketo, Salesforce and Oracle Service Cloud.If you want to read more about this subject, you should check out my colleague Sumit Sarkar’s blog post: SQL Server Linked Server ODBC connection to Salesforce from Management Studio.
Click on the Security page and select Be made using this security context. Then enter your DataDirect Cloud username and password.
Click on the Server Options tab and ensure that they match the following options shown in the following screen capture.
That’s it! You’re all done! Now you’re ready to connect to more data sources than ever before.
Idaliz is a Sales Engineer with Progress. After receiving her undergraduate degree from Duke University in Civil and Environmental Engineering, Idaliz Baez spent a year at NASA Goddard Space Flight Center gaining on-the-job experience before returning to Duke in pursuit of her Masters of Engineering Management degree.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.