Pega Robotics Studio: connect to MS Access database
Following the example in this post, I am trying to establish a connection to a MS Access database and select the contents of one table: https://community1.pega.com/community/pega-support/question/robotics-studio-integrate-access-db However, despite selecting "Access Database Engine" (refer '1set.png'), completing the settings and successfully testing the connection (refer '2test.png'), when I exit out of the data link property window the connection string has referred to "SQL Server" (refer '3revert.png'). Opening the data link property popup again, sure enough the data provider has been automatically forced back to "SQL Server" (refer '4revert.png') and test connection now fails. Why does the provider revert to SQL Server? Or is there another/better way to connect to an MS Access table?