Creating a custom extract from a jasper report

Comments

8 comments

  • Official comment
    Avatar
    Franck Reyherme

    Hi Muneiza,

    Unfortunately, it is not possible to create a custom extract from a BI Tool report.

  • Avatar
    Muneiza Ahsan

    Thanks Franck! any other solutions that you know of

  • Avatar
    Brian Cortes

    How about a custom report? Just extract the data as an Excel file.

  • Avatar
    Muneiza Ahsan

    Hi Brian,

    Some times the third party applications have a very specific need and custom report does not accomplish that. Some times, I have to make two or three reports in Illuminate then join them  outside Illuminate to create a data extract (which then becomes a manual process). 

     

  • Avatar
    Brian Cortes

    Hi Muneiza,

    OK, got it. We deal with third party entities in my district as well, and yes, custom reports often falls short. What we do is query the Illuminate database using SQL, which allows us to structure the extract data to the third party's exact specifications. You mentioned BI Tool reports, so I'm assuming you have ODBC access to the Illuminate database.

  • Avatar
    Muneiza Ahsan

    Hi Brian,

    We do have ODBC access to illuminate and trying to find a way to automate the task.  We use pg admin  and tried installing pg agent and no luck. That is why I tried the jasper way...but no luck in this route too. 

    Are able to automate any task based on SQL

    Thanks a lot! I feel like I am not the only one in this boat. 

  • Avatar
    Casey Mirch

    Hi Muneiza,

    Our automation routines of that sort generally involve a Windows batch script orchestrating different steps and dumping command output to a log file. The SQL query is performed and the results are written to a file by psql, the PostgreSQL command-line client which I know is included in a basic installation of PGAdmin 3. Then WinSCP uploads the file to the 3rd party vendor's SFTP site. The batch script is launched by Windows Task Scheduler on some server. That glosses over a lot of details, but I'd be happy to share a working example.

    Alternatively, general-purpose data integration utilities like Talend provide a way to build all the steps in one place using a graphical interface.

  • Avatar
    Muneiza Ahsan

    Hi Casey, a working example  will be great as I am a newbie in this area. I will explore talend as well mean while.

    Thanks a lot! 

Please sign in to leave a comment.