Access OF Arena Backend DB?

Dear all

We use a Postgres DB to manage our data. It would be great to be able to access the OF Arena backend directly from our DB using a foreign data wrapper. So we could automate data processing without the need for a csv export.

Is it possible to get access rights to the Arena backend; access to the survey_xx_data schema of the survey would be sufficient.

Thank you Christoph

arena

asked 12 Dec '24, 12:01

chris_1123
41●6
accept rate: 0%

edited 12 Dec '24, 12:42

One Answer:

active answers oldest answers newest answers popular answers

Dear Christoph,
In Arena we use one database with several schemas, 2 schemas for each survey (one with the survey definition and the data, another one with the data in a relational format, which is the survey_xx_data schema you would need).
To achieve what you need, we should be able to create a user in the database who can access only a specific schema, but as far as I know, with PostgreSQL you cannot grant such permission and avoid that a user can view other schemas too.
We will contact you to your private email address, to better understand your needs.
Thanks,
Open Foris Team

permanent link

answered 12 Dec '24, 22:59

Stefano (OF) ♦♦
4.9k●1●1●9
accept rate: 19%

Your answer

toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

arena ×63

question asked: 12 Dec '24, 12:01

question was seen: 179 times

last updated: 12 Dec '24, 22:59

Access OF Arena Backend DB?

Follow this question

Related questions