Lesson 3: Vulcan XML File structure

As you’ve seen in HelloWorld.xml of Lesson 1, the Vulcan XML file has a clear structure which enables the file itself easy to read and modify. You may have understood the basic grammar by just looking at HelloWorld.xml. Here’s the detailed explanation: <Vulcan xmlns=”http://tempuri.org/vulcan2.xsd”> </Vulcan> All the table definitions, ETLs should only exist in <Vulcan>…


Vulcan Lesson 2: Editing XML files

XML files are the input of Vulcan. You can choose your own favorite XML editor to work with them. To save time in editing, it’s strongly suggested to set the correct schema file for these XML files. For example, if you’re using Visual Studio, open the “Properties” Window of the current XML file, and click…

1

FAQ: What is Vulcan?

Vulcan is a Business Intelligence Framework built on top of Sql Server Integration Services and Sql Server Analysis Services for quickly creating BI solutions.

1

Vulcan Lesson 1: Hello, World!

As every programming language book, we’ll start from the “Hello, World!” sample. Starting from now, we’ll work on our own test database, with a name “TestDataWarehouse”. So you need to create a database with the same name in your SQL Server. The first Vulcan XML file looks as simple as below: “HelloWorld.xml” <?xml version=”1.0″ encoding=”utf-8″…

1

Vulcan Lesson 0: Set up work environment

To work with Vulcan to develop BI solutions, you need the following things installed on your development machine: ·        Microsoft SQL Server 2008 with Integration Service ·        Microsoft .NET Framework 3.5 ·        Vulcan binaries ·        Microsoft Visual Studio 2008 (Optional) You can get .NET Framework 3.5 from Microsoft Download Center http://www.microsoft.com/downloads/en/default.aspx , and get Vulcan…

1