Configuration file.

1

Is there a way to configure Metabase so that when an image is created with docker compose and the connection is made to a database (e.g. Postgres), the data does not have to be reconfigured for another database and all data can be passed to it. that data in a file.

2

sorry, I'm not getting the last part of the problem, you want to configure questions from one db to run on a second db?

3

I have a container running with an Oracle image on my localhost and I want to make a connection from the metabase to that database, but automated with a playbook in Ansible with the following code:

  • name: Create Oracle database
    uri:
    url: http://{{ metabase_server }}/api/database
    method: POST
    headers:
    Content-Type: "application/json"
    X-Metabase-Session: "{{ login_id }}"
    body_format: json
    body:
    {
    "name": "oracle",
    "engine": "oracle",
    "details":{
    "host": 172.23.10.104,
    "port": 1521,
    "ORACLE_SERVICE_NAME":"",
    "ORACLE_SID":"ORCL",
    "ORACLE_CHARACTERSET":"AL32UTF8",
    "user": "",
    "ORACLE_PWD": "oracle"
    }
    }

I have already tried many ways to enter each of the "details" but it always tells me that I have to enter the SID. I have already achieved this with mongodb and postgres, but with oracle it has been impossible. Could you tell me what is wrong or incorrectly configured? Thanks for the help.

4

I’m not an expert on Ansible, but have you tried checking what is the exact body that Metabase has when adding an Oracle database?

There is a demo stack here https://github.com/paoliniluis/metabase-oracle/blob/main/setup/setup.py