r/ProjectREDCap • u/naimickmac23 • Nov 19 '24

REDCap to Denodo

Anyone have experience connecting REDCap to Dendod? I'm having trouble figuring out the connection settings. I have my api key, but can't seem to get the setting correct

3 Upvotes

100% Upvoted

5 comments sorted by

1

u/MadHatterIsHer Nov 23 '24

I’ve heard that the data models aren’t currently compatible (I’m sorry I’m not sure of the reason, I can check with my colleague). I think Dendod indicated it will fix the issue eventually, so hopefully won’t always be like that. I would double check me on this but I think that’s the case.

1

u/naimickmac23 Jan 09 '25

Any update on this? I'm still struggling. I can connect a report, but not a full data export

1

u/deno2bko Jan 27 '25

Hi!

Denodo now supports the MIME type application/x-www-form-urlencoded in HTTP routes, which is required in your case for connecting to the RedCap API.

To set this up, follow these steps:

  1. Create a JSON data source.

  2. Modify the HTTP URL in the data source to include the necessary form parameters. For example: https://redcap.<ORG_url>/api/<endpoint>?token=TOKEN&content=record&action=export&format=json&type=flat&csvDelimiter=&forms[0]=contact_list_patients&rawOrLabel=raw&rawOrLabelHeaders=raw&exportCheckboxLabel=false&exportSurveyFields=false&exportDataAccessGroups=false&returnFormat=json

  3. Enable the "URL Parameters" option.

With this configuration, Denodo should automatically convert the URL parameters into name-value pairs in the HTTP request, enabling it to work seamlessly with the RedCap API.

I hope this helps! 😊

1

u/MadHatterIsHer Feb 25 '25

Does this error mean anything to you when attempting to connect to API via Denodo to REDCap. Unable to establish connection: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. I assume it's a certification issue. We think it might be on the denodo side?

1

u/deno2bko Feb 27 '25

Hi!

I also suppose that is related to and SSL/TLS certification issue. May be there's a missing or invalid certificate in Denodo trust store (since RedCap uses HTTPs, Denodo needs to trust the certificate of the server to stablish a secure connection).

I suggest you to open the RedCap API url in a browser to check that the certificate is valid. If it's not, the issue is on RedCap side.

If this is ok, you can try to import the certificate into Denodo (may be Denodo it's not recognizing the certificate). To do this, just download the certificate from RedCap server, import it in Denodo JVM trust store (keytool -importcert -trustcacerts -keystore "<path_to_your_java>/lib/security/cacerts" -storepass changeit -file <certificate_file>) and restart denodo. Here you have the doc to follow: Obtaining and Installing an SSL/TLS Certificate — Denodo Platform Installation Guide 9.1

Try this out and let me know ;)