Jan LollingDatenbanken und Business Intelligence mit Open Source


Project SQLRunner

Screenshot SQLRunner

Features

  • Use JDBC (Java Database Connectivity minimum JDBC 1.0 spec is quite enough)
  • Shipped with a large number of preconfigured JDBC drivers
  • Works with host based database like Siemens SESAM
  • Keep all your connections (with passwords optional) for direct access in login dialog and give them clear names
  • Explore the data model for all connections (with databases, schemas, tables, views (including source code), stored procedures, indexes and constraints)
  • Count datasets of tables and memorize counts with time stamps
  • Compare schemas and create modeling statements to update the target schema
  • Import flat text files as well as Excel spreadsheets (xls, xlsx)
  • Use batches for high performance imports
  • Explain-Function (if database provide this feature, currently implemented for PostgreSQL and Oracle and NEW for Apache Derby Database and NEW for MySQL)
  • Gather source code for procedures and views (if database provide these features, currently implemented only PostgreSQL and Oracle)
  • Export a query without collecting all datasets within the memory
  • Import all tables from a schema
  • Export all tables from a schema
  • All imports and exports can run parallel in multiple instances
  • Run SQLRunner in Linux, Mac OS X and Windows as a local installation or via Java Web Start technology
  • Generate code for Java/PHP from your tested statements and vice versa extract pure SQL from a larger selection of Java code containing the SQL as string
  • Run stored procedures with in/out parameters
  • Run prepared statements with in/out parameters
  • Use a large list of useful preconfigured SQL to administrate your database
  • Sort your retrieved datasets without repeating your select statement or create a select statement for this kind of sorted result set
  • Toggle the result table orientation to see all columns of all datasets in a single column (useful for large content in columns)
  • Use a comfortable full featured text editor for the field content
  • Syntax assistance using CTRL+Space key
  • Upload and download binary data in BLOB fields
  • Load and execute cascaded scripts (cascaded loading and executing using the start command)
  • Talend Function added: From Metadata model you can export a table as talend schema

nach oben


ANT-Tasks

Screenshot SQLRunner

Purpose

  • Develop with Java
  • Build with ANT
  • Run under Linux

ANT is the Swiss knife for building/deploying Java based applications.
Especially its very easy extensibility is the main reason why you find ANT nearly everywhere. It was a pleasure for me to learn ANT by developing extensions (called task) to provide a bit more comfort in my build processes.

These tasks are licensed under the Lesser GNU License (LGPL).

Tasks

  • Icon Code Creator Task
    Create a java class which references all icons/images as static accessible objects. If you integrate that task before compiling your project sources you will find all missing images/icons!
  • JNLP Task
    Creates a JNLP Descriptor
  • PropertyMergeTask
    Merge different property files (e.g. to support different build goals) and convert them into ASCII format.

nach oben


About

Studium
  • 1987 - 1990 Fachschule der Deutschen Post Leipzig: Abschluss Ingenieur für Rundfunktechnik
  • 1990 - 1992 Hochschule für Technik und Wirtschaft Berlin: Abschluss Dipl.Ing. für Nachrichtentechnik
Beruf
  • 1990 - 1999 Ingenieur für Planung und Betrieb von Rundfunksender-Überwachungsanlagen:Projekt QSS-RA in der Deutschen Telekom AG
  • 1999 - 2009 Softwareentwickler und Berater in der T-Systems
  • 2009 - 2011 Projektmanager für BI, DWH Projekte in der T-Systems
  • 2009 - heute Gastdozent an der Hochschule für Wirtschaft und Recht Berlin im Bereich Wirtschaftsinformatik:
    • Business Intelligence DataWareHousing
    • Objektorientierte Programmierung
    • Software-Engineering
    • Webanwendungen
  • 2011 - heute IT-Consultant CIMT Objects AG - BI und Datawarehouse Projekte
photo of Jan Lolling Jan Lolling
Work: Berlin,
Germany
Tel (mobile): +49 175 5618141
E-Mail:
Netzwerk

nach oben