How to provide access to data in hosted multi-tenant database for reporting and analytics

How to provide access to data in hosted multi-tenant database for reporting and analytics

July 26, 2012 0 Comments

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?

  • SMB end users required access from SSIS to hosted SQL Server database with shared schema architecture.
  • End users running Jasper Reports want to run ad hoc queries from an enterprise web application built on MySQL in shared schema architecture.  The database did not support separate schemas and creating separate databases was not practical.
  • A health care provider needed to expose subsets of data in a shared database to different Cognos Report Developers.

Benefits for choosing OpenAccess for your SaaS application:

  • No changes are required to your SaaS application database architecture when providing secure and trusted access to your existing multi-tenant data.
  • Build brand recognition by providing drivers exclusively for use with your hosted SaaS application.  You can read case studies from existing customers such as NetSuite and Hewlett Packard.
  • Have your clients get even more out of their hosted data for reporting and analytics across the entire business.  If your hosted data is important, it should be in the hands of business intelligence teams.
  • Get ultimate flexibility from access to data access logic.  For example, if your SaaS database has a highly normalized schema, use OpenAccess to expose a logical data model or presentation layer against the existing data appropriate for business intelligence.
  • OpenAccess ODBCJDBCADO.NETOLEDB, SSIS clients are built from the flagship DataDirect Connect codebase already running in end user environments, either directly or bundled from one of our 300 ISVs.

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 Sakar

Sumit Sarkar

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.

Comments are disabled in preview mode.
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
More From Progress
Then, Now and Beyond: The Future of Back Office Software
Read More
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More