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 ?

 

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.

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

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