Using oracle as DataSource in superset with Docker

[ilyakitaev]

Hello, just as a solution and for future development.

Quick fix

1. First you need to download oracle client with libraries and put them into superset image
2. install cx_Oracle and libaio1 inside container
   apt update; apt install -y libaio1; pip install cx_Oracle
3. For normal language support set env variable in the docker/.env
   NLS_LANG=RUSSIAN_RUSSIA.AL32UTF8 # for Russian with UTF-8
4. Superset does not detect oracle and uses postgres specs for that datasource. So you need to comment this line to fix SQL Lab error
   superset/db_engine_specs/postgres.py +52
   # cursor.tzinfo_factory = FixedOffsetTimezone

hope it will be helpfull

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[nk-fouque]

I think I have the problem you fix with your 4th point, but doing that didn't change anything, should I restart something ?

[ilyakitaev]

I think I have the problem you fix with your 4th point, but doing that didn't change anything, should I restart something ?

can you provide any logs? That was quickfix for demo, m.b. I can help you

[nk-fouque]

Thanks
The only error I have is when I run queries in SQL Lab : oracle error: 'cx_Oracle.Cursor' object has no attribute 'tzinfo_factory'
I run it from the docker image so I don't really know where to look for the logs, I can provide them if you tell me

[ilyakitaev]

Thanks
The only error I have is when I run queries in SQL Lab : oracle error: 'cx_Oracle.Cursor' object has no attribute 'tzinfo_factory'
I run it from the docker image so I don't really know where to look for the logs, I can provide them if you tell me

m.b. you really need to restart container with docker-compose restart after fixing sources. If you recreate containers with down/up your fix will be removed

You can view logs with docker-compose logs