Creating a custom extract from a jasper report

Follow

Muneiza Ahsan

December 04, 2018 23:18

Hello,

I am having  difficulty creating a pg agent  so we can  create a custom extract to send data to different vendors.

To overcome, I created a report in jasper  and pushed it back to illuminate so I can generate a custom extract; but stuck again as I dont see this option when I pushed it back as a pre built.  

Any help  will be deeply appreciated. Thanks in advance!

0

• Official comment

  

  Franck Reyherme December 05, 2018 14:33

  Hi Muneiza,

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

  Permalink
• 

  Muneiza Ahsan December 05, 2018 15:45

  Thanks Franck! any other solutions that you know of

  0

  Permalink
• 

  Brian Cortes December 07, 2018 16:14

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

  0

  Permalink
• 

  Muneiza Ahsan December 07, 2018 17:02

  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). 

   

  0

  Permalink
• 

  Brian Cortes December 07, 2018 17:37

  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.

  0

  Permalink
• 

  Muneiza Ahsan December 07, 2018 17:48

  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. 

  0

  Permalink
• 

  Casey Mirch December 07, 2018 18:23

  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.

  0

  Permalink
• 

  Muneiza Ahsan December 07, 2018 19:07

  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! 

  0

  Permalink

Please sign in to leave a comment.