community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Creating Alteryx Alias SQL OLE connection

Highlighted
Alteryx
Alteryx

In some cases, you may need to use an OLE Microsoft SQL connection as opposed to the default ODBC connection when setting up an Alias. These are the steps it took for me to get this to work.

 

  1. In "Mange Data Connections" dialog select "Other".
  2. Next to connection string select "OleDB..."
  3. For OLE DB Provider(s) select: "SQL Server Native Client 11.0"
  4. Under connection tab create connection and check "Allow saving password".
  5. Note avoid using passwords with equal signs in them. This seems to cause issues.
  6. Click Test Connection to make sure it is good but don't click OK yet.
  7. Click on the All Tab.
  8. Click on Integrated Security and leave value blank then click OK to Edit Property Value. This adds something to the connection string that may be needed even when the value is blank.
  9. Scroll down and open the Persist Security Info and change the Property Value to "True". then click OK.
  10. Test connection one more time and then click OK and you should be good.
Labels