06-20-2016 01:32 PM
Are there plans for SAS to support additional data vendors? I am particularly curious about MongoDb, which is one of the most ubiquitous NoSQL databases, with perhaps the largest reservoir of programmers for a Hadoop solution.
Is this strictly a technical question, or is it primarily a business question, from both the side of SAS and outside vendors?
07-12-2016 08:33 AM
I am the product manager for SAS/ACCESS and our Hadoop-related products. I think we have some confusion here.
We are constantly evaluating third party data sources, such as MongoDB, to see if we will create dedicated SAS/ACCESS products. As Linus pointed-out, SAS does not develop ODBC drivers to third-party data sources. The database vendor, or another third party, creates ODBC drivers for third party databases.
Our SAS/ACCESS Interface to ODBC product will work with ODBC 3.5 compliant databases. DataDirect and Simba have created ODBC drivers specifically for MongoDB. There may be a driver that you can download from the MongoDB site. A MongoDB ODBC driver combined with SAS/ACCESS Interface to ODBC will enable you to access data which is stored in MongoDB.
There is a SAS Global Forum paper on SAS/ACCESS to ODBC that may be of help to you.
Whether, or not, we create a SAS/ACCESS engine depends upon the strategic interests of SAS. Many factors go into the decision. Unfortunately, I cannot discuss this. I have taken the liberty of submitting your request to our internal tracking system. I can't make any promises, but your request is in the system.
I may be wrong, and I apologize if I am, but you appear to be mixing Hadoop support with that of MongoDB. MongoDB is not an Hadoop distribution. Our list of supported Hadoop distributions is available on the web (SAS 9.4 Supported Hadoop Distributions).
The support statement for non-Hadoop SAS/ACCESS products are available are available in the systems requirements for SAS Foundation. For example - Systems Requirements for SAS 9.4 Foundation for Linux for x64.
06-20-2016 04:00 PM
A quick search for MongoDb indicates there are ODBC drivers available. This means SAS/ACCESS to ODBC is a possibility. You could check with SAS Tech Support to see if they are aware of anyone using ODBC with MongoDb.
06-20-2016 04:08 PM
I assume the ODBC drivers are developed by SAS, right? Is that a technical or business decision, do you think?
When I go to:
I found on page 9:
A commercial Hadoop distribution is the collection of Hadoop components (such as HDFS, Hive, and MapReduce) that is provided by a vendor. Many commercial Hadoop distributions include additional proprietary software. SAS supports commercial Hadoop distributions from Cloudera, Hortonworks, IBM InfoSphere BigInsights, MapR, and Pivota
06-20-2016 04:11 PM
No, SAS only develops ODBC drivers for its own data sources.
ODBC drivers are usually developed by the DB vendor, or a 3rd party.
06-20-2016 04:18 PM
No by third parties as @LinusH says. A Google search popped up several possibilities, for example:
06-20-2016 05:07 PM - edited 06-20-2016 05:08 PM
I appreciate your replies--at the risk my appearing too dense, what does this mean in real life? Does it mean that other DBs have not developed drivers for SAS, which makes little sense to me from a business standpoint, unless there is something about certain databases that makes such development not technically feasible? Or, is it the absence of some sort of business relationship with SAS that would be a necessary prerequisite to that kind of development?
In other words, how does this statement from SAS fit with your answer?
SAS supports commercial Hadoop distributions from Cloudera, Hortonworks, IBM InfoSphere BigInsights, MapR, and Pivota
06-20-2016 05:27 PM
Well I guess it is impossible for SAS to develop custom interfaces to all databases, hence they support just those for which there is sufficient commercial demand. For those databases where a custom interface does not exist a generic interface like ODBC (Open Database Connectivity) is still possible.
We use SAS/ACCESS to ODBC to work with SQL Server. There is nothing wrong with this approach and many ODBC solutions work very well.
06-20-2016 06:09 PM
06-20-2016 10:34 PM
06-20-2016 11:24 PM
06-21-2016 12:11 AM
My two cents worth is that SAS has to make resource allocation decisions on which third-party data management products to provide additional support for, beyond "generic" ODBC interfaces. I'm not familiar with the NoSQL domain, but if you feel that SAS should invest in MondoDB, you can certainly make a case to your SAS office.
In my opinion, if you can round up a bunch of SAS clients who also use MongoDB, and who would benefit from additional features that might be provided by an extended SAS interface, I think that SAS would be very receptive. Basically, you simply have to demonstrate that there's a customer base large enough to make it worth their while.
On the other hand, if MongoDB is terrifically popular, but all of the people who use it except for you have no interest in SAS, that will make it a very tough sell.
06-21-2016 02:21 AM
Need further help from the community? Please ask a new question.