SaaS Multi-tenancy Applications: How is data import/export/backup being implemented?

Posted by Mark Redman on Stack Overflow See other posts from Stack Overflow or by Mark Redman
Published on 2010-04-18T09:30:31Z Indexed on 2010/04/18 9:33 UTC
Read the original article Hit count: 228

Filed under:

saas

|

multi-tenant

|

sql-server

|

backup

|

export

How are applications providing import / export (or backups) of data in SaaS based multi-tenancy applications, particularly single database designs?

Imports:

Keeping things simple I think basic imports are useful, ie CSV to a spec (or a way of providing a mapping between CSV columns and fields in the database.

Exports:

In single database designs I have seen XML exports and HTML (basic sitse generated) exports of data? I would assume that XML is a better option? How does one cater for relational data? Would you reference various things within XML and provide documentation of the relationships or let users figurethis out?

Are vendors providing an export/backup that can be imported back in/restored?

Your comments appreciated.

© Stack Overflow or respective owner

Related posts about saas

How does cross domain authentication work in a firewalled environment?

as seen on Server Fault - Search for 'Server Fault'
This is a simplification and the names have been changed to protect the innocent. The assets: Active Directory Domains corp.lan saas.lan User accounts [email protected] [email protected] Servers dc.corp.lan (domain controller) dc.saas.lan (domain controller) server.saas.lan A one way trust exists… >>> More
Livre Cloud computing et Saas : Une rupture décisive pour l'informatique d'entreprise de Guillaume P

as seen on Developper.com - Search for 'Developper.com'
Avant de lire ce livre, Cloud Computing et SaaS étaient pour moi des termes que j'avais entendu, sans jamais vraiment clairement comprendre le concept. La lecture de ce livre dévoile petit à petit ces définitions, et en ce sens remplit tout à fait son rôle. Retrouvez la critique complète en ligne... >>> More
Oracle's Software as a Service (SAAS) Model

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Listen to Anthony Lye, Senior Vice President, Oracle CRM, talk about how customers can benefit by incorporating Oracle's leading Enterprise Grade SAAS architecture to support their CRM footprint. >>> More
Múltiples clientes en el mismo Oracle UCM

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Estamos muy activos con la implantación de plataformas ECM que den servicio a múltiples clientes. Consiguiendo 2 objetivos muy importantes:El cliente final puede pagar al proveedor por una plataformas ECM como servicio (SaaS). Y, lógicamente, se ahorra en complejidad y gastos de infraestructura, administración… >>> More
Agile SOA Governance: SO-Aware and Visual Studio Integration

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
One of the major limitations of traditional SOA governance platforms is the lack of integration as part of the development process. Tools like HP-Systinet or SOA Software are designed to operate by models on which the architects dictate the governance procedures and policies and the rest of the team… >>> More

Related posts about multi-tenant

How to configure Multi-tenant plugin as single-tenant with Spring security plugin as resolver?

as seen on Stack Overflow - Search for 'Stack Overflow'
I can create a secure, multi-tenant web app with Grails by : setup spring security plugin, setup Multi-tenant plugin (via multi-tenant install and multi-tenant-spring-security) update config.groovy : tenant { mode = "multiTenant" resolver.type = "springSecurity" } add : Integer userTenntId… >>> More
How to Test a Multi-Tenant App with support for multiple domains

as seen on Stack Overflow - Search for 'Stack Overflow'
HI, we are building a multi-tenant application, which will support that each tenant can have a unique top level domain, the application is build using the asp.net 3.5 and SQL servr 2005, while each tenant will have different database. I have seen a number of questions about the similar applications… >>> More
Introduction to Multi-Tenant Architecture

as seen on Internet.com - Search for 'Internet.com'
Learn how to create websites with similar functionality yet different UIs and maintain them across one shared code base using Multi-Tenant Website Architecture. >>> More
???????????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Database 12c??????”???????”????????????????????????????????????????????Oracle Database 12c????????·?????????????????? (EnterpriseZine/DB Online)???????Oracle Database 12c R1????VI? ???????·??????? (?????) ??????????????????????????????????????????????????????????Wiley??”Dummies… >>> More
EC2 hosted service multi-tenant dynamic DNS solution

as seen on Server Fault - Search for 'Server Fault'
I want to change the model of my EC2 hosted service to have a separate sub domain for each tenant (ie. .example.com). My primary DNS is now with dnsmadeeasy.com, but their dynamic DNS offering seem pretty weak: it requires the API to use my full dnsmadeeasy.com account credentials, I rather have… >>> More