Hi @artmov 

 

If your SQL server is API enabled such as Azure SQL, you can create a Nintex Xtension for your service, using this then you will be able to add that service as a data source.

 

https://help.nintex.com/en-US/xtensions/Home.htm

 

Hope this helps

Jake

---

Hi @Jake,

Xtention is a good tip. Thank you. I experimented with Xtentions in connection with Data Lookup control. It works, but the problem is that you cannot filter the results. When you a SharePoint Data Source in Data Lookup control, then the Editor gives you an option to set a filter dynamically, which makes the results set customizable for any specific case on the form. On the other hand, when I use Xtention Data Source, then there is no filter and there is no way to set an input parameter. Thus the Data Lookup is always populated with the same data, which makes it static and not very useful.
Do you have any suggestions in that regard?
Thank you.

---

Hi @Jake,

I need to tell you that my previous comment is probably outdated. Since you gave me this direction, I went to my old solutions, which stopped working , and tried to rebuild them. It turns out that now I can pass a parameter to an Extension connecting to API and pass parameters. My form drop-down is updated dynamically. Pretty nice.
Now, I will need to create an API connecting to SQL.

Thank you again for a nice tip.

---