support oracle？

[vkingnew]

support oracle？

[mbasmanova]

Are you asking for an Oracle connector? I'm not aware of anyone working on that. Would you like to make a contribution?

[mbasmanova]

Actually, looks like it might be available from Starburst: https://docs.starburstdata.com/latest/connector/oracle.html

[vkingnew]

I means to presto connects to oracle.Like MySQL or SQL server in official documents.

[mbasmanova]

@vkingnew The link above says that Starburst has developed Presto connector for Oracle and makes it available for a fee. It seem that they haven't contributed that connector to the open source though.

[bendemott]

I'm working on an Oracle connector to submit as a patch.

I see someone submitted a patch but didn't really have the interest to finish it - I'm hoping to finish it, write, tests, and update some documentation. I'll base the configuration parameters on the commercial Starburst connector.
#11540

I also see this (very outdated) github exists:
https://github.com/marcelopaesrech/presto-oracle

I could use help and input on how to integrate a test with Travis CI to validate the driver.
Suggestions welcome.

There are docker containers/vms that contain test versions of Oracle Database

• https://www.oracle.com/technetwork/community/developer-vm/index.html
• https://github.com/oracle/docker-images/tree/master/OracleDatabase

I'll get a repo up next week and update here. If anyone would like to help please let me know.

[bendemott]

@tooptoop4
Update - I've updated the oracle connector to Presto 0.225 and updated maven to build the extension as a stand-alone JAR for testing.
We're currently using 0.225 for testing at my organization - I'll update to the Presto latest soon, and then keep it updated from then on.
I'll create an "official" repo once it's stable. My plan is to build tests and test automation next.
I'm actively working on this.

https://github.com/bendemott/presto-with-oracle

I have pending updates that I'll commit this week, I'll add pre-built JAR's as well.

TODO:

• Connection Pool Support (optional)
• Tests / Test Automation using Docker / Oracle Database
• Tests with different version of the Oracle Client Driver

[moizmuhammad]

@bendemott Is pre-built JAR available?

[palashgoel7]

#15014 has already added this