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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
New Data Science Blog

Check out the latest post: All Models Are Wrong

READ MORE
Announcement | We'll be doing maintenance between pm 4- 6pm MT, which may impact your experience. Thanks for your patience as we work on improving the community!

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