We managed to get Informatica to work by using 4 SSL certs (3 by lithium and 1 open ssl), and our middleware developer calling informatica support. So it does work it just takes 4 weeks of trial and error ;)
Cheers Oliver. We have been successful in setting up curl to generate the CSV file, so this part is done and we can increment by 1 day at time as we want the call to not time out as the files are pretty huge. Informatica is looking for a certificate in either of the 2 formats: CER or PEM. We will see what other options we can use, but will let the BI engineer know about the openssl option. Once we get this working will circle back on our approach as we might have to experiment with out own certificate. Thanks again for your feedback.
We managed to get Informatica to work by using 4 SSL certs (3 by lithium and 1 open ssl), and our middleware developer calling informatica support. So it does work it just takes 4 weeks of trial and error ;)
Hey OlivierS,
Thanks for the comment on the 4 security certs. Yeah, pretty crazy, but are using the 3 browser SSL certs plus the open SSL one. I guess Informatica is a bit strict ;) Ha. I think the idea is they want to replicate the browser HTTPS for the API? Anywho, we are still working on the BULK API and a few more questions popped up and wanted to get another round of people's feedback. If you have time, take a look. I would appreciate your feedback on those questions too!
Cheers,
Tim
