I have been working with an increasing number of organizations that deployed a hosted multi-tenant database, and are now looking to expose data to individual tenants for reporting purposes. With the increased adoption of SaaS, many organizations are feeling pretty good about their data being hosted. However, challenges may be introduced when clients require SQL access to their data for reporting and analytics. The solution to avoid a potentially costly architectural overhaul is DataDirect OpenAccess. The most common data access use cases we see are in shared schema architectures. However, for the more isolated architectures, we are starting to see various security requirements from end users. And if you're interested in learning about the latest technologies in multi-tenant databases that solve this challenge, check out what's new in OpenEdge 11: Multi-tenancy Overview and Multi-tenancy Getting Started. How does DataDirect OpenAccess work? OpenAccess enables organizations to enforce tenant level security at the driver level without touching the hosted architecture. This is done by writing a couple lines of code within two methods that build a robust set of data access clients (ODBC, JDBC, .NET, OLEDB) to support applications such as Microsoft SQL Server BI Suite (SSIS, SSRS, SSAS), Informatica, DataStage, Ab Initio, SAP Business Objects, SAP Data Services, IBM Cognos, Microstrategy, OBIEE, Pentaho, JasperSoft, Actuate and many more.
What are some recent use cases you have seen?
Benefits for choosing OpenAccess for your SaaS application:
Get Started Today! Install Progress DataDirect OpenAccess SDK using the Progress DataDirect OpenAccess SDK Installation Guide. You can download DataDirect OpenAccess SDK and get started or call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with DataDirect OpenAccess solutions for multi-tenant databases. Tell your end users that you're considering DataDirect for solving their data connectivity requirement, and post a blog comment to share their excitement. After all, we are the worldwide leader in providing SQL access to multi-tenant data.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.