Statistica uses standard Microsoft Data Link dialog to list the drivers available. For SQL Server - there are two providers listed - Microsoft OLEDB provider for SQL Server and SQL Server Native Client 11.0.  What is the recommended driver ?

 

What is the recommended driver to retrieve data from SQL Server into Statistica?

The Microsoft OLEDB Provider for SQL Server is the recommended provider for retrieving data from SQL server into Statistica. The recommendation is for this driver is for 2 reasons

1. SQL Server Native Client has been deprecated by Microsoft . See : https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15
2. The Native client does not allow for storing passwords. As a result the user will be prompted for password every time the data is retrieved from SQL Server.

NOTE : If using both the above mentioned providers is not viable option for some reason, another way to pull data from SQL Server into Statistica is to define a System DSN/ User DSN in Control Panel >> System And Security>> Administrative tools >> ODBC Data Sources using the SQL Server/SQL Server Native Client 11.0 ODBC driver.




From Statistica, data can then be retrieved using "Microsoft OLEDB provider for ODBC" driver and picking the User/System DSN defined in ODBC Data Sources while defining the database connection.

https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/
https://support.tibco.com/s/article/What-SQL-Server-ODBC-driver-should-be-used-when-TLS-version-1-2-is-enabled
https://support.qlik.com/articles/000004087