Generate your XML Data File from any Data Source (ODBC)

Aioob Visual XSL Designer can automatically create an XML document from almost any data source via an ODBC connection. You simply select your data source (Access, Excel, Oracle, SQL Server, MySQL, FoxPro, Paradox...) and Aioob Visual XSL Designer will create the XML file for you.

How it works.

1.	Select your data source:

data source

2.	Design your XML layout:

XML layout

3.	Generate your XML code:

XML code

Data Source into XML

1.	Start Aioob Visual XSL Designer.

2.	Select the Generate your XML Data File from any Data Source (ODBC) option from the XML Data File dialog box, and press OK:

Generate your XML Data File from any Data Source (ODBC)

3.	From the XML Database Converter wizard select Database from the menu, to view the list of available data sources:

XML Database Converter wizard

- If your database is not listed on the menu, then you may have to download the driver for that specific database or data source to work with ODBC. We suggest you search google for them, using the following key words odbc driver for database name. For example if you were trying to access data from MySQL, but MySQL was not listed in the menu then searching google with the following keywords (odbc driver for mysql) will give you the following result. Download and install the drivers for your database, then restart Aioob Visual XSL Designer to access your data source via this same menu.

4.	Use the ODBC to connect to your database or data source:

data source

5.	You will now be able to view your data. At this point you can use SQL to refine the data you want to use:

To manually edit SQL, select Edit > SQL from the menu. Use the SQL Editor box to try and test your SQL.

SQL Editor box

To visually edit SQL, select Edit > Visual SQL from the menu. Use the Visual SQL wizard to filter your data.

Visual SQL wizard

6.	Once you are happy with the Data, press the Next > button to continue. You will now be able to edit the basic layout of your XML document:

Edit the basic layout of your XML document

You can:

Use the Table Section to quickly add, remove or edit the data you want to use within your XML document.

Use the Tree Section to edit the layout of your XML document. You can drag-n-drop or move each node. All properties can be access via the Edit/Insert menu.

7.	Once you are happy with the layout, press the Next > button to continue. You will now be able to see the XML code:

XML code

8.	Your Data has now been turned into XML. Press the Finish button to save your XML and VXSL files and give them a name.

9.	You can now design your XSL document.