DBXL v2.8

DBXL Training, Feb 2014

Kaoru Okumura — Tue, 16 Sep 2014 03:57:40 GMT

DBXL Online Training Video from Feb 2014 session is here:

http://www.youtube.com/playlist?list=PLUFfSqJwJ1hnMMUmt6hX8-I4drrli9ppH

This play list includes 5 videos:

Qdabra DBXL Training, day 1 1:09:59
Qdabra DBXL Training, day 2 1:44:22
Qdabra DBXL Training, day 3 1:50:30
Qdabra DBXL Training, day 4-a 10:51
Qdabra DBXL Training, day 4-b 52:13

Qdabra DBXL Training - Module 7

ErnestoM — Fri, 28 Feb 2014 13:55:22 GMT

This module contains a few tips and tricks useful for any DBXL Administrator.

Qdabra DBXL Training - Module 6 - ReportBuilder and QueryDocumentNodeSet

ErnestoM — Fri, 28 Feb 2014 13:54:28 GMT

In past modules we have seen how DBXL can map data to a SQL database, and how QueryDB can query data from a SQL database.

What if you want to query form data DIRECTLY from the XML forms? QueryDocumentNodeSet is a web service included in DBXL, and Report Builder is its interface. With ReportBuilder you’ll be able to create a report that extracts data from the XML files. With QueryDocumentNodeSet you can create data connections to query XML data directly into your form.

Qdabra DBXL Training - Module 5 - QueryDB

ErnestoM — Fri, 28 Feb 2014 13:52:47 GMT

Using the QueryDB web service included in DBXL, we can set up our InfoPath forms to query data from SQL databases. This lab will walk you through an example.

Qdabra DBXL Training - Module 4 - Active Directory web service

ErnestoM — Fri, 28 Feb 2014 13:51:35 GMT

Active Directory includes a wealth of information about your company’s organization. This module will show you how to auto-populate fields in your InfoPath form with the email address and full name of the currently logged on user.

Qdabra DBXL Training - Module 3 - Database mapping

ErnestoM — Fri, 28 Feb 2014 13:50:26 GMT

Using DBXL you can create mappings from your XML forms to your SQL tables.

In order to execute the steps in this document, you will need an InfoPath form that submits to DBXL. Luckily, we have already done this in the first two modules.

This module is compatible with both scenarios discussed so far in this training: Event Receiver and Integrated.

Qdabra DBXL Training - Module 2 - Event Receiver scenario on SharePoint 2013

ErnestoM — Fri, 28 Feb 2014 13:49:19 GMT

Using the Event Receiver, the InfoPath form does not need to be modified to include the data connection that submits to the DBXL Web Service. The InfoPath form template submits to a SharePoint form library, and the Event Receiver maps those forms to DBXL.

This scenario is most important for SharePoint 2013. Therefore, the tutorial in this document will focus on SharePoint 2013. However, the steps should be similar if working on SharePoint 2010. The Event Receiver has not been tested in SharePoint 2003 or 2007.

Contrary to the integrated scenario, DBXL does not need to be installed on the SharePoint site. In fact, DBXL can be installed on a different site or even a different server!

Qdabra DBXL Training - Module 1 - Integrated scenario on SharePoint 2010

ErnestoM — Fri, 28 Feb 2014 13:45:19 GMT

The first two modules of this training session will illustrate the main scenarios when using DBXL. We begin with the “classic” scenario, that is, the scenario Qdabra has recommended to its customers using DBXL v2.7 or earlier versions.

We call this scenario “Integrated” because DBXL is installed on the SharePoint – 80 site. This module will be executed on SharePoint 2010, whereas Module 2 will present a different scenario preferred for SharePoint 2013.