Does the Excel Add-in product use native connectivity or must ODBC data sources be configured before using it?
In particular, I would like to know about connectivity to PGSQL and MSSQL databases.
Native DB connections?
Re: Native DB connections?
Excel Add-ins is supplied with embedded providers (including providers for connecting to PostgreSQL and SQL Server).
Re: Native DB connections?
All providers are available in the Trial version. When evaluation period ends, you should choose Devart Excel Add-in for particular server(s): http://www.devart.com/excel-addins/ordering.html.