This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at https://www.izenda.com/docs/
Izenda reports is designed as a modular system to be easily customizable for usage with any datasources. The AdHocContext
class has a Driver property containing an instance of the Izenda.AdHoc.Database.Driver
abstract class, which provides datasource metadata for Izenda AdHoc. All datasource drivers in Izenda AdHoc use this as their base class and layer functionality on top of it.
Figure 1: The standard Izenda Driver model. Datasources are separate and the driver handles the heavy lifting of interacting with the datasources.
The Izenda.AdHoc.Database.MSSQLDriver
class implements complete functionality for using MSSQL server as your datasource and also allows you to create inheritors. So the easiest way to create a custom driver working with MSSQL server is to inherit Izenda.AdHoc.Database.MSSQLDriver
and override the functionality you need to work differently. Below are complete instructions detailing how to perform this:
1. Create new project with type of Class library in Visual Studio.
Figure 2:
Figure 3:
using Izenda.AdHoc.Database; namespace CustomDriver { public class MyCustomDriver : MSSQLDriver { } }4. Now any metadata drilling functionality can be altered. Here we will implement overriding of two most important methods, assuming that we have a single custom source of data. For our example, we will assume the table Products exists with three fields: Id, Name, and Price:
a. GetAllTables()
returns an array of Izenda.AdHoc.Database.Table
which will be available in the DataSources tab in the ReportDesigner as a list of datasources. Here is a short example of overriding this method:
public override Table[] GetAllTables() { Table[] result = new Table[1]; result[0] = new Table("Products"); return result; }b. GetColumns returns an array of Izenda.AdHoc.Database.Column for the given table. This array is used as fields list at several tabs in the ReportDesigner. Again, short example of overriding this method: public override Column[] GetColumns(Table table) { if (table.Name == "Products") { Column[] result = new Column[3]; result[0] = new Column("Id", SqlType.UInt32); result[1] = new Column("Name", SqlType.VarChar); result[2] = new Column("Price", SqlType.Float); } else { throw new Exception("Unknown DataSource"); } }
The overridden fields can be seen in the Fields tab on the Report Designer after selecting the DataSource "Products" at the DataSources tab.
Include a reference to your CustomDriver
to your website. To perform this, the following steps should be taken:
a. Compile your CustomDriver
project and copy the assembly to your website's /bin folder, and add the reference just like above.
b. Set AdHocContext.Driver = new CustomDriver
in the Session_Start()
or Application_Start()
method.
You must also override some other methods like GetDataSet()
. This method accepts a System.Data.IDBCommand
parameter, and returns the corresponding DataSet. Overriding this method allows you to pre-process the dataset before returning it. You may use AdHocContext.CurrentReportSet
to get additional details of the report. For integrations that will not utilize SQL queries in the command object, Izenda.AdHoc.AdHocContext.CurrentReportSet
may be used to get the report state.
To override this method, simply add following strings to the MyCustomDriver class:
public override DataSet GetDataSet(IDbCommand Command) { DataSet result; result = base.GetDataSet(command); //If you want the driver to obtain DataSet and process it before returning //result = new DataSet(); //If you want to implement your own method for obtaining a DataSet. //more processing.... return result; }
You can also see more coding examples here.
The Izenda Fusion Driver composes data sources from several connections (data providers) into a single data source. This is very similar to how SSAS works, but using Fusion you can aggregate data not only from MSSQL databases but from very different data sources. For example, you can get data from the OData data provider (i.e. without a direct connection to the database). All you need to do is set up the data sources' connections and you will be able to work with aggregated data as a single data source.
Figure : Schematics of how the Fusion Driver interacts with different datasources. Instead of working with individual datasources, it aggregates the datasources into one.
Configuring the Izenda Fusion Driver is almost the same as configuring the Izenda Driver with single connection. The main differences are:
Configuring the Izenda Fusion Driver consists of several steps:
At first you should create FusionDriver object and set up it as default driver for the Izenda AdHoc. Here is example how to do it in C#:
FusionDriver fusionDriver = new FusionDriver(); AdHocContext.Driver = fusionDriver;
Now you can add connections to the data sources end points. The end point could be a direct connection to the MSSQL database or it can be an OData connection to the MSSQL or Oracle database.
You should specify the connection nickname in first parameter, the connection type of MSSQL in the second parameter, and the connection string in the last parameter:
fusionDriver.AddConnection("SqlNW", FusionConnectionType.MsSql, "server=(local);database=Northwind;Trusted_Connection=True;");
You should specify the connection nickname in first parameter, the connection type of OData in the second parameter, and the link to the OData end point in the last parameter:
fusionDriver.AddConnection("OrclNW", FusionConnectionType.OData, "http://www.providerdomain.com/provider_endpoint.aspx");
The Izenda Fusion Driver has several additional settings:
This is setup the same way as for a single connection. Only data sources with the specified names will be available:
fusionDriver.VisibleDataSources = new string[] { "Orders", "Customers", "Order Details" };
This is setup the same as for single connection except that you are able to specify separate constraints for each connection by using connection nicknames. Note that you can use wildcard characters to set up constraints:
fusionDriver.AddConstraint("SqlNW/Order.Id", "SqlNW/*.OrderID"); fusionDriver.RemoveConstraint("OrclNW/Account.Id", "OrclNW/User.AccountID");
If reports are stored in the database you should specify connection string to that database. Note that in addition to this, you should also use FusionAdHocConfig instead of DatabaseAdHocConfig. The following example sets up the connection string to the database using the reports table. If you store reports in the file system then skip this step(use FileSystemAdHocConfig if you do this).
((FusionAdHocConfig)AdHocSettings.AdHocConfig).ReportingConnectionString = "server=(local);database=Reports;Trusted_Connection=True;";
Getting data from several data source providers may take a lot of time and resources when many connections are added. This will result in a slow connection to the providers due to large amount of data being transferred, etc. That’s why the cache is enabled by default for the Izenda Fusion Driver. By default, cache expiration time is set to 12PM on Saturday. This means that every Saturday, the cache will be cleared and all data will be requested from the providers during the next session.
You can configure the cache yourself by using the following properties and methods:
fusionDriver.DataCacheExpiration = DateTime.Now.AddDays(-2);
fusionDriver.CacheAllReports();
fusionDriver.CacheReport(string reportFullName);
Below is a full example of how to set up and configure the Izenda Fusion Driver with several connections and reports stored in your database:
<%@ Application Language="C#" %> <%@ Import Namespace="System.Data"%> <%@ Import Namespace="Izenda.AdHoc.Database"%> <%@ Import Namespace="Izenda.AdHoc" %> <%@ Import Namespace="System.Configuration" %> <script runat="server"> void Session_Start(object sender, EventArgs e) { // Set license key. Note: "+FUSION" must be in license key AdHocSettings.LicenseKey = "LICENSE KEY"; // Set config. Note: config class must derive from FusionAdHocConfig or FileSystemAdHocConfig AdHocSettings.AdHocConfig = new CustomFusionAdHocConfig(); // Create Fusion driver and set it as default driver for AdHoc FusionDriver fusionDriver = new FusionDriver(); AdHocContext.Driver = fusionDriver; // Add connection to the local MSSQL database fusionDriver.AddConnection("SqlNW", FusionConnectionType.MsSql, "server=(local);database=Northwind;Trusted_Connection=True;"); // Add connection to the OData provider which is connected to the Oracle database fusionDriver.AddConnection("OrclNW", FusionConnectionType.OData, "http://www.providerdomain.com/Oracle/FusionEndpoint.aspx"); // Add visible data sources fusionDriver.VisibleDataSources = new string[] { "Orders", "Customers", "Order Details" }; // Configure constraints for connections fusionDriver.AddConstraint("SqlNW/Order.Id", "SqlNW/*.OrderID"); fusionDriver.RemoveConstraint("OrclNW/Account.Id", "OrclNW/User.AccountID"); // Clear cache fusionDriver.DataCacheExpiration = DateTime.Now; // Add some reports to the cache fusionDriver.CacheReport("Financial reports\Sales"); fusionDriver.CacheReport("Common reports\Employees"); // Set connection to the database with reports table ((FusionAdHocConfig)AdHocSettings.AdHocConfig).ReportingConnectionString = "server=(local);database=ReportsDB;Trusted_Connection=True;"; } [Serializable] public class CustomFusionAdHocConfig : FusionAdHocConfig { public override void ConfigureSettings() { } } </script>
Last edited by Joseph Adams, 2018-01-25 16:50:12