We need to find the best way to form a connection. How do we go about this? Would it be best to do it on-prem and download the extractor server? If so Would a JDBC connector work? But don't we need to open up access to any firewall ports if needed for that-which is a problem in our case-right? We have thought about the ServiceNow connector offered by Celonis however I think we cannot use it due to the firewall issue. Would an extractor builder work? Celoxtractor via python? What alternatives can we use?
Question
We are trying to form a connection between data warehouse servers (where the ServiceNow data we need is located) and the celonis cloud, but we are not allowed access to the firewall for security policy reasons, so what is the best connection method?
+6
+26Hi @shreya.kulka,
Most of the time the firewall blocks incoming connections. Therefore I would suggest an on-premise extractor to load your data in Celonis. In this case, the on-premise extractor creates an connection from inside the network towards, which isn't blocked most of the time.
Since you are mentioning a data warehouse, I suppose you want to use a database connection. In this case the JDBC extractor would be the right choice. Some databases are directly supported, for others you have to add a database driver, as mentioned here: How do I set up a database connection using a custom JDBC driver? (celonis.com).
The JDBC connector accept SQL statements that are generated from the Data Ingestion section. If your database have a very specific SQL dialect or if you want to push API endpoint data using an on-premise extractor, the Celoxtractor method should be used, but this is rarely the case.
Extractor Builder won't work in this situation, since this is an incoming connection to the application, which will most likely to be blocked by the firewall.
Hopefully this helps.
Kind regards,
Jan-peter
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.