Hi everyone,
I know if I wanna retrieve data from SQL Server per ETL, there are either ODBC or JDBC options, but I just wanna know in SAS, if there are other possibilities to get data from SQL Server, I have found SAS has an engine SQLSVR, I have tried, but somehow it needs still the ODBC connection created in ODBC source, is it the case? So I don't have any other choices but only using ODBC to access SQL Server, do I? Thanks for replying.