Home Services Partners Company
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

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. 

Comments
Comments are disabled in preview mode.