topic Re: SAS + Domo in Administration and Deployment

SAS + Domo

analyticsguy23 — Wed, 29 Mar 2023 19:20:16 GMT

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!

Re: SAS + Domo

ErikLund_Jensen — Wed, 29 Mar 2023 19:46:45 GMT

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.

Re: SAS + Domo

SASKiwi — Wed, 29 Mar 2023 19:59:41 GMT

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.

Re: SAS + Domo

analyticsguy23 — Wed, 29 Mar 2023 20:18:28 GMT

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

Re: SAS + Domo

SASKiwi — Thu, 30 Mar 2023 00:03:24 GMT

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.