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.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, 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.