SAS + Domo

[analyticsguy23]

Hello-

User of Domo and want to bring SAS Datasets into Domo.

Was wondering if anyone has done that before, and if so, how.

Thanks in advance!

[ErikLund_Jensen]

Hi @analyticsguy23 

I haven't tried it, but I think ihe easiest way would be to write data from SAS to a database table and read the database table from DOMO. There are several prerequisites for this:

• A database (MSSQL, MySQL or PostgreSQL) that is accessible from both SAS and DOMO.
• A running SAS platform with a separately licensed Access Module for the database.
• A DOMO license for the proper Database Connector.

An alternative, that would work without a database and a SAS Access Module, could be to export from SAS to a CSV file and import it in DOMO using a CSV Connector. There prerequisites here are:

• A file system that is accessible from both SAS and DOMO (might be the tricky part)
• A running SAS platform 
• A DOMO license for the CSV Connector.

[SASKiwi · Accepted solution]

That's probably a question you should be asking on a Domo forum. You can always resort to CSVs if there is no better way. If Domo has an ODBC connector SAS could push data to Domo using the SAS/ACCESS to ODBC product. To do that you would obviously need a working SAS installation.

[analyticsguy23]

Thanks! Is that pretty much the same way that SAS would connect to Tableau Data? 

[SASKiwi]

Yes. The other option as described by @ErikLund_Jensen would be to push data into a third-party database like SQL Server that both SAS and Domo have access to.