Collibra Integration with Workday (JDBC)

Hi Kristen - do you know of any customers that have used the Workday JDBC / Collibra Integration ? We would be interested in talking to any about their experiences. Thanks !

@arthur.burkhardt Have you used the Workday JDBC / Collibra Integration by chance?

@barry.goldstein No, but I used the Salesforce JDBC connector which is similar I believe.
The JDBC connector pulls data in a strictly relational format, which typically provides 90% of the information you would want to get. In the case of Salesforce, you won’t be able to retrieve picklist data for example.

Do you want to govern the operational data behind Workday? Because another possibility would be to catalog the workday data in the staging area of your data lake/data warehouse, given you have sufficiently broad coverage of the model.

I am also interested in understanding Workday’s integration success story and outcomes. It would be nice if we can hear some key points and lessons learned of the integration from the experienced user. It’s in my roadmap as well.
@barry.goldstein, Were you able to integrate analytical/reporting pipeline? What is RAAS inetgration?

Thank you,
Sweeti

Hi Sweeti - What we did is we used a few key reports we created in Workday to extract metadata: (a “data dictionary” type report, a report of all of our custom reports and metadata, and a report of all of our dashboards and all of the associated metadata. Then using REST APIs we extracted and loaded the metadata into our Azure Data Factory. We then did some additional transformation and used REST APIs to load into Collibra. The integration is good and in working fine in our Collibra production environment. However, there is some key metadata we did not capture like values. In addition, we are curious as to what the actual Workday - Collibra integration connector will look like.

Thank you so much for taking the time to explain the use case and integration method. I was missing the reporting side of the capabilities. This is helpful. I will share information with my internal team.
I am also curious to understand the values and benefits of registering workday via catalog. So far, I have integrated Oracle, SQL Server, and MarkLogic databases with catalog. It brings the relational database structure (schema, tables, and columns) and its metadata in DGC. It has automated the manual ingestion progress and scheduling the job is convenient. I have started working on profiling ingestion capabilities via catalog. Thanks!

Hello @ravi_collibra , were you able to connect to Workday using Oauth and ingesting metadata successfully?

Hi @ebrahim.roshdy.kyndryl.com,

We were able to connect to the DEV instance.

In PROD, facing SSL handshake issues. Had a word with collibra support, they say there is a firewall issue, however, I am able to ping the host from the server.

In SSLServerCert, I have used *, which accepts all certificates, still it’s not working.

Could you please help @george.cheung.collibra.com @pranay.mahendra

Regards,
Ravi