search

schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.62k stars 200 forks source link

SchemaCrawler and Workday #1061

Closed jseaman-idata closed 1 year ago

jseaman-idata commented 1 year ago

Feature Request

It's possible to connect to Workday using OAuth2 and enable queries against Workday's WQL (custom version SQL for workday). Since SchemaCrawler doesn't recognize the database type, it goes to default queries that fail (from examining the logs, which I've attached here it seems that starts with data type examination). I may be wrong about what's broken here, but I do know metadata discovery is possible with Workday. As it's a platform gaining wide popularity, it may be worth getting metadata discovery working here. schemacrawler.log Run in Windows Server 2019 with SchemaCrawler version: 16.15.4

Possible Alternatives

The JDCB Driver I'm using to connect to workday supports jdbc metadata gathering through java.sql.DatabaseMetaData. Does SchemaCrawler already have an option to do this? If not, maybe that's the better/faster to done approach.

Additional Context

No response

jseaman-idata commented 1 year ago

The JDCB Driver I'm using to connect to workday supports jdbc metadata gathering through java.sql.DatabaseMetaData. Does SchemaCrawler already have an option to do this?

sualeh commented 1 year ago

@jseaman-idata SchemaCrawler uses java.sql.DatabaseMetaData to gather metadata. I would be able to assist you further if I had access to Workday, and knew what JDBC driver you were using.

I recommend that you use the latest version of SchemaCrawler, and the CDATA JDBC driver for Workday, even though it is not free. If you need more help, please refer to the consulting information.

jseaman-idata commented 1 year ago

Great advice. Access to workday is hard for us too. We created our tools without access. Fun, I know. We are partners with CData and distribute the CData workdriver to our clients. I did notice this class: schemacrawler.schemacrawler.MetadataRetrievalStrategy.

I'm using the SchemaCrawler API. I'm guessing there's a way to set this option. Does the latest version work better with workday? Upgrading SC in the past has included adjusting for a lot of refactoring. You are quite prolific in updating your code. If 16.15.4 works about as well as the latest with Workday, maybe I'll delay upgrading.

Thanks, Jeff

sualeh commented 1 year ago

@jseaman-idata Jeff, do you still want to keep this request open?

sualeh commented 1 year ago

Closing due to no activity.