Creating a custom extract from a jasper report
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!
-
Official comment
Hi Muneiza,
Unfortunately, it is not possible to create a custom extract from a BI Tool report.
Comment actions -
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.
-
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.
-
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.
Please sign in to leave a comment.
Comments
8 comments