ETL using Perseus

Javier · May 12, 2022, 12:36pm

Hey

Does anyone has expereince using Perseus tools

for their ETL.

We would like to have a continuous-develoment-like ETL.
Meaning that we can easyly make changes in out ETL and run the data thougth it to experiment different options. Perseus seems a good tool for this.

jposada · May 12, 2022, 4:37pm

I was not even aware of this, who is developing this beauty!

We should have them in our community call

@admin @Patrick_Ryan @CraigSachson @ekatzman

MPhilofsky · May 12, 2022, 6:42pm

@e.alex and Anton Ivanov presented Perseus on the HealthCare Systems (formerly EHR WG) call November 12, 2021. In the HealthCare Systems Teams space you will find notes with links in the “EHR to OMOP WG Meeting Minutes” doc. And under the Files > Recordings you will find the recording of the Nov. 12th call

Javier · May 13, 2022, 6:23am

@jposada, I also recomemend to watch the recording that @MPhilofsky suggest. It has some important details I didnt see at first in the wiki. For example, the ability to create intermediary tables.

Reza_Baharmand · May 13, 2022, 8:05am

Hi dear,
I could not find the link to the presentation.
if you have the link please add it here.
many thanks.
best
reza

bradanton · May 13, 2022, 11:28am

https://www.ohdsi.org/2021-global-symposium-showcase-79/

MPhilofsky · May 13, 2022, 1:16pm

Here’s the link to the Perseus presentation recording from the Healthcare Systems interest group meeting.

jposada · May 16, 2022, 5:31pm

oh my… I was not aware of that community call. Thank you @MPhilofsky !!

MPhilofsky · May 17, 2022, 2:42pm

The EHR WG is now known as the Healthcare Systems group And we now meet at 10am every other Monday. Our next call is Monday, May 23rd.

cgsmw · May 17, 2022, 3:36pm

@Javier - I have been working with it a bit. Still Beta. It is a very promising tool. The deployment instructions are good for setting up on Docker Desktop. To see the full power you’ll need a source dataset or sample CSVs.

e.alex · June 14, 2022, 11:25am

@Javier if you need any assistance or would like to know more, please feel free to write me at alexander.efimov@softwarecountry.com

We are very interested in getting to know your use cases and evolve the tooling based on that.

Sanjay_Udoshi · March 3, 2023, 5:11pm

Thank you for your kind assistance in helping us install and run Perseus. As you know I was having a strange problem with a conflict on port 5000.

I found the issue! And I wanted to alert you so that you can inform the broader community of potential users who might try to use Docker Desktop for Mac OS, especially since Monterrey and currrently with Ventura releases of the OS.

Apple uses port 5000 for incoming requests to Airplay music from devices to the MacOS machine. Turning this off is simple:

Again, thank you for your prompt response and the branch you provided on GitHub!