Need recommendations for ETL tools

Hello,

We have been using an ETL tool (Extract, Transform, Load) to connect an in house Notes application database to an external SQL database. The tool, Replic-Action developed by Casahl, is no longer being developed or supported. Does anyone have any recommendations for a currently supported application that is compatible with the latest version of Domino and Windows OS, and supports connectivity to SQL Server, and/or other cloud SaaS applications?

We have several customers that use HCL Enterprise Integrator to integrate between Domino applications and external databases. The back-ends supported by the product include DB2, SQL Server, Oracle and MongoDB. Here is a link to the HEI welcome documentation: https://help.hcl-software.com/hei/hei_welcome.html

Hi Brett,
you also could use HCL Link - https://www.hcl-software.com/link?referrer=www.google.com

Thank you @Kim Greene and @Rainer Brandl for your replies. I will check into those products. Ironically, I asked HCL Support the same question in a support case and they did not have a solution, except to post here in the community.

@Brett Zuder you're very welcome. The answer you received from HCL is quite ironic. I have a customer that opened a Case with HCL (prior to them finding my company), asking if they could integrate with DB2 on the IBM i from their Domino applications. After a month, the support team said it can't be done. It very unfortunate when customers aren't able to get accurate information on questions like these.

Hi Brett Zuder,
Thank you for your query.

We understand that you are looking to perform ETL to connect your in-house Notes application database with an external SQL database. There are two possible approaches to achieve this:

Using ODBC LotusScript Classes:
You can write LotusScript classes to leverage the ODBC connection for connecting the SQL database to your Notes database. This will allow you to extract, transform, and load the required data directly from SQL to Notes.


Using HEI (HCL Enterprise Integrator):
Alternatively, you can install the HEI in your environment. Once installed, you can create the appropriate connection between Notes and ODBC and generate activity documents for direct data transfer. This method will also allow seamless insertion of documents from the SQL database into the Notes database without issues.

For additional information please refer the following product documentation.

Title : Accessing external databases through LS:DO
URL --> https://help.hcl-software.com/dom_designer/12.0.2/basic/H_ACCESSING_EXTERNAL_DATABASES_THROUGH_ODBC_USING_LOTUSSCRIPT.html

Title : Welcome to the HEI documentation
URL --> https://help.hcl-software.com/hei/hei_welcome.html

We hope this provides clarity on your options.

Thank you,

Regards,

Sridhar