Hi all. We have a requirement to connect to MS SQL Server databases hosted on AWS from 4D v17.3 on Mac OS 10.14+. The use case scenario is likely to be that: * only a single user will need to connect, either via 4D Client or from 4D standalone - tbc * we may need to ingest large amounts of data from SQL Server into 4D tables in order to analyse it - the developer wishes to do this from 4D for his convenience * the requirement is most likely one-way read only from MS SQL Server and write to 4D - tbc
If my initial investigations are correct we need: * an ODBC manager * SQL Server ODBC driver For the ODBC manager it seems there are really only 2 choices - both free: * http://www.odbcmanager.net - ODBC Manager * http://www.iodbc.org - iODBC For the ODBC driver there seems to be these options - requiring licences: * http://www.actualtech.com * https://www.openlinksw.com It looks like ODBC Manager is supported and maintained by Actual Technologies who can also provide a driver. Does anybody have recent experience of connecting to MS SQL Server from 4D v17 on Mac OS 10.14? If so: * what combination of driver manager and SQL Server driver worked for you - was it from the ones I have listed or some other? * could you kindly elaborate on your experience - connection, reliability, driver stability, performance, etc * any other useful pointers for consideration? Regards, Narinder Chandi, ToolBox Systems Ltd. https://toolbox.systems I am available for new consulting opportunities… http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.html -- ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
