27 04, 2015

GenericDB connector in Jedox Integrator (usecase: Firebird relational database)

By |2016-12-09T11:42:51+00:00April 27th, 2015|Categories: How To|Tags: , , , , , , , |

Jedox Integrator offers a lot of connections to different systems, but what if we have a database and it is not offered in the list of connections. Jedox Integrator offers the ‘GenericDB’ connection, with this connection we can connect to any source if they offer a JDBC driver. JDBC driver (short form of Java Database Connectivity) , is defined as

15 04, 2015

TableLoop Transform in Jedox Integrator

By |2016-12-09T11:42:53+00:00April 15th, 2015|Categories: How To|Tags: , , , , , , |

One of my favorite components in Jedox Integrator is the TableLoop, with a very easy configuration you can do pretty cool stuff with it. I ran in an example that I will like to describe in this article. If you don’t have a good background in Jedox Integrator, you may need to download the complete example with the link given

2 03, 2015

ETL from Excel

By |2016-12-09T11:42:56+00:00March 2nd, 2015|Categories: How To|Tags: , , , |

Month ends are like haircuts. Towards the end of the process, there are a lot of little snips and clips. Enter month-end adjusting journal into ERP, run Jedox Integrator, rinse, repeat. The adjustments can go on for a long time, so an easy way to process them is critical. Having a custom Jedox web page to run jobs helps, but

16 01, 2014

Combining filter criteria for multiple selections in cube extracts

By |2016-12-09T11:43:32+00:00January 16th, 2014|Categories: How To|Tags: , , |

Our good friend, world champion sailor and Jedox expert Sebastian Moser has offered up a cool post around getting a little more sophisticated with cube extracts in ETL: Sometimes, you might want to Export data from a Jedox database to a DWH or other systems. Occasionally, you don’t quite get the correct result from ETL cube extract with provided filter