[
https://issues.apache.org/jira/browse/NIFI-12443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17791780#comment-17791780
]
crissaegrim edited comment on NIFI-12443 at 11/30/23 8:59 PM:
--------------------------------------------------------------
Hi [~exceptionfactory]. It's not something they publicly advertise. You have
to be a subscriber and they provide you with documentations on Geneva core
server, `runrep` utility (which you use to run RSL and GSQL), etc..
I do have some expertise on it because I work on data engineering on Geneva for
my company, so I can put together a PR based on what I know. And I do have
documentations on Geneva, RSL lang, GSQL lang specs, etc... But I hesitate to
supply it as it's not something you can google. I can barely find some docs
online by googling and there are some public blogs and git repos ({if you look
hard enough) (e.g.
https://thinkinginsoftware.blogspot.com/2012/02/running-advent-geneva-rsl-remotely.html)
that gives hints on how it works.
So what it is, is RSL files (think of them as saved query files) deployed on a
host. The processor needs to log in via SSH and call a utility called
`runrep`. You supply it with some accounting commands (start date, end date,
portfolio). Runrep will either output to standard out or CSV file. The CSV
file can then be ingested by a reader.
Again, I can put together a PR and it can be reviewed by the community.
And you're right! Very niche--hedge funds use this! But it'll be very useful
to support if done correctly.
was (Author: JIRAUSER298664):
Hi [~exceptionfactory]. It's not something they publicly advertise. You have
to be a subscriber and they provide you with documentations on Geneva core
server, `runrep` utility (which you use to run RSL and GSQL), etc..
I do have some expertise on it because I work on data engineering on Geneva for
my company, so I can put together a PR based on what I know. And I do have
documentations on Geneva, RSL lang, GSQL lang specs, etc... But I hesitate to
supply it as it's not something you can google. I can barely find some docs
online by googling and there are some public blogs and git repos ({if you look
hard enough) (e.g.
https://thinkinginsoftware.blogspot.com/2012/02/running-advent-geneva-rsl-remotely.html)
that gives hints on how it works.
So what it is, is RSL files (think of them as saved query files) deployed on a
host. The processor needs to log in via SSH and call a utility called
`runrep`. You supply it with some accounting commands (start date, end date,
portfolio). Runrep will either output to standard out or CSV file. The CSV
file can then be ingested by a reader.
Again, I can put together a PR and it can be reviewed by the community.
And you're right! Very niche--only some hedge funds use this! But it'll be
very useful to support if done correctly.
> Add Geneva RSL query record processor
> -------------------------------------
>
> Key: NIFI-12443
> URL: https://issues.apache.org/jira/browse/NIFI-12443
> Project: Apache NiFi
> Issue Type: New Feature
> Reporter: crissaegrim
> Assignee: crissaegrim
> Priority: Minor
>
> h1. SS&C Geneva
> SS&C Geneva is a global fund accounting and portfolio management solution
> that provides real-time access to detailed portfolio data and a flexible
> reporting system. It is widely used by hedge funds, asset managers, mutual
> funds, and fund administrators for its ability to handle complex securities
> and multiple currencies.
> h2. Geneva RSL
> In the context of SS&C Geneva, RSL stands for "Report Specification
> Language". It is a programming language provided by Geneva for writing custom
> reports. With RSL, you can query the Geneva database, perform calculations,
> or format and output data. The RSL scripts are usually stored as .rsl files
> on the server hosting the Geneva application.
> h2. Runrep Utility
> Runrep is a command-line utility in Geneva. It facilitates the execution of
> RSL files from the command line. This feature is particularly useful for
> automating report generation or scheduling tasks without having to manually
> operate the Geneva user interface.
> Here's why including a Geneva RSL Processor can be beneficial:
> # Integrating a Geneva RSL Processor in NiFi can allow direct interaction
> with RSL files and the Geneva database
> # With a dedicated processor, you can automate the process of executing RSL
> files and scheduling tasks without manually having to use the Runrep
> command-line utility
> Some good names for such a processor...
> - `GenevaRSLExecutor`
> - `RSLReportProcessor`
> - `GenevaRSLIntegrationProcessor`
> - `GenevaRSLScheduler`
> - `QueryGenevaRSL`
> - `QueryGenevaRSLRecord`
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
