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 ;)
We are having trouble setting up Informatica to establish the connection. That is out current issue. The advice we are getting from informatica is to use a client certificate issued by a certification authority (with public/private keys) only to be used to authenticate the user. At the moment Lithium holds the certificate and their advice is they we get our own (so we have the private key) but we are unclear if this will work, which is why I'm reaching out the community.
If people are using a tool to connect via Bulk API did they have to use their own client certificate for it to work? We are also working the Informatica end to understand what other options we have to try and establish a connection. Thanks for your input.
tmarshall I'm far from being an expert, so the below might not be correct!
I would first advise you to have a go without Informatica. Curl is probably the easiest way to start:
curl “https://eu.api.lithium.com/lsi-data/v1/data/export/community/<community_id>?fromDate=YYYYMMDDhhmm&to...” –H “client-id: <client-id>” –u “<token>:”
If your instance is not in EMEA, then the command will be:
curl “https://api.lithium.com/lsi-data/v1/data/export/community/<community_id>?fromDate=YYYYMMDDhhmm&toDat...” –H “client-id: <client-id>” –u “<token>:”
Use a tiny date range for your tests as you will see you will pull tons of data.
The command lines have been truncated, please refer to our Bulk API guide.
Once it's working fine, move to Informatica. I'm not sure why you would need to install a certificate as the calls are made using https. But, if Informatica insists of you installing a certificate, just get the Lithium one. Try this command line:
openssl s_client -connect eu-api.lithium.com:443
or, if in the US
openssl s_client -connect api.lithium.com:443
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.
