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 ;)
