SQL Integration

Side-by-side Document Types to preserve SQL mapping when your form schema changes

ErnestoM — Tue, 17 Jan 2012 19:58:22 GMT

DBXL allows you to create mappings from XML field to SQL columns. However, a problem arises if your schema changes drastically: the existing XML documents will not be compatible with the new form. How can you handle this situation? Here's one way. Click DOWNLOAD above.

Using the Encryption Tool for web.config connection strings

ErnestoM — Tue, 17 Jan 2012 19:47:33 GMT

If your DBXL instance needs to use SQL connection strings that contain sensitive information, such as usernames and passwords, you can use this simple encrypt tool to convert them into an encrypted form. To obtain the document and the tool, click DOWNLOAD above.

A free trial of DBXL is available on Qdabra.com.

How to Create Database Mappings in DBXL

ErnestoM — Tue, 17 Jan 2012 19:45:50 GMT

Qdabra's Database Accelerator (DBXL) allows you to create customized mappings between your XML documents and a SQL database. This document will cover the following:

Database Mapping for a non-repeating group
Database Mapping for a nested, repeating group
Conditional Shredding
Mapping DBXL Tokens
How to report shredding errors to form users
Working with large database mappings
Indexing makes shredding faster

To obtain the document, click DOWNLOAD above. A free trial of DBXL is available on Qdabra.com.

How to Create SQL Report using DBXL Web Service

ErnestoM — Tue, 17 Jan 2012 19:32:24 GMT

With DBXL v2.3 and later, you can easily convert your xml documents data into a complex SQL schema of your design which facilitates all kinds of reporting. This document will show you how reporting can be managed in SharePoint using standard export to excel functionality and how reporting can be enhanced by using Qdabra’s DBXL Web Service. Please click on DOWNLOAD to obtain this document.

Use DBXL tokens for Database mappings

ErnestoM — Tue, 17 Jan 2012 18:59:38 GMT

This document explains the DBXL tokens, which are present in every XML document stored in DBXL and available for Database mapping. Click DOWNLOAD above to read this document.

The QueryDB Permissions Plugin Interface

ErnestoM — Tue, 17 Jan 2012 18:49:38 GMT

Starting with version 2.2, DBXL includes a mechanism for defining custom permissions to the QueryDB and DatabaseEnumeration web services. You can utilize this interface to restrict certain sensitive databases and tables that should not be exposed by the web service at all, or you can permit access to certain databases and tables for only certain users or roles.

This download provides the details for the permissions plugin API that you can use to define your own custom plugin, and includes a sample plugin that you are free to adapt to your own use.

Mapping a Date value from InfoPath to SQL using DBXL

ErnestoM — Thu, 16 Jun 2011 16:36:04 GMT

Scenario: You want to map DATE from InfoPath to SQL DATE data type

Issue: DAT only has a “DateTime” DB Type in the dropdown.

Click DOWNLOAD above to obtain workaround steps for this issue.

SQL Mapping for rich text fields using DBXL

ErnestoM — Wed, 11 May 2011 14:27:07 GMT

Starting with DBXL v2.4, the Qdabra Web Service has added support for mapping rich text into the SQL database. Click DOWNLOAD above to obtain a document with more information.

DBXL v2.5 QueryDB User Manual

ErnestoM — Fri, 01 Apr 2011 17:36:29 GMT

The QueryDB web service, included in Qdabra's Database Accelerator (DBXL), allows you to obtain data from SQL tables and use it in your InfoPath forms. This document is the User Guide for anyone interested in learning more about QueryDB.

To obtain the document, click DOWNLOAD above. A free trial of DBXL v2.5 is available on Qdabra.com.

Implement Static and Dynamic queries using QueryDB on DBXL v2.5

ErnestoM — Fri, 01 Apr 2011 17:32:01 GMT

The QueryDB web service, included in Qdabra's Database Accelerator (DBXL), allows you to obtain data from SQL tables and use it in your InfoPath forms. This document is a tutorial demonstrating the usage of QueryDB.

To obtain the document, click DOWNLOAD above. A free trial of DBXL v2.5 is available on Qdabra.com.