AnsweredAssumed Answered

What options to connect to MS SQL data sources from Nintex Forms?

Question asked by hagarm on Mar 17, 2015
Latest reply on Jun 8, 2016 by hagarm

I am new to Nintex Forms2013, and I am trying to figure out how to best integrate with MS Sql databases.  This is what I have tried so far:

 

- I have made external content types in Designer, and I also can make external lists from those content types.  But it doesn't appear that Nintex Forms doesn't see 'External Lists' in the 'List Lookup' control.

- I have played with the 'External Data Column' control.  The only way I can successfully see data, is when the 'Display format' is set to Default.  That isn't at all the user experience I am looking for.  When I attempt to change the type to drop down, I get blanks at runtime.  I made the suggested 'wildcard' filter in the external content type, and still no results.

-I did a quick test of a third party add on by Prosymmetry, which seems to work.  But we don't want to have to purchase a commercial product.

 

In Infopath I can make whatever database connections I need, and then filter those dropdowns based on values within another field.  I can also use rules to query those data sources when necessary.   As far as I can tell, this doesn't seem possible with Nintex Forms.  I am hoping am wrong, and someone can point me in the write direction. 

 

Any assistance would be greatly appreciated!

Outcomes