Connecting DataFactory to Lotus notes DB

0
votes

I have a requirement to connect to lotus notes DB which is there in On-Prem. There is no built-in connector available in Azure DataFactory V2) to connect to it.

I've read an article about how to get data from lotus notes:

  1. Using ODBC driver connection.
  2. .Net code to read it.

Did anyone tried above possibility ? If so let us know whether it is possible, and if so what are Pros & Cons.

1
azurelotus-notesazure-data-factory-2
I'm not familiar with Azure, but could you use REST calls, to use Domino Access Services? See ibm.com/developerworks/community/blogs/LotusSupport/entry/… – D.Bugger

1 Answers

0
votes

Have you tried using the ODBC connector from data data factory? I have never had to use it, but im pretty sure it will work as any other.

Just go to Connections, click on New, then type ODBC and fill the form! Make sure to select the on premise integration runtime when filling the form, so it connects through that to the database.

Here are some screenshots to help you:

New Linked Service

ODBC Selection

Fill the form

Hope this helped!