BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
analyticsguy23
Calcite | Level 5

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!

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
Opal | Level 21

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.

View solution in original post

4 REPLIES 4
ErikLund_Jensen
Rhodochrosite | Level 12

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
Opal | Level 21

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
Calcite | Level 5

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

SASKiwi
Opal | Level 21

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 298 views
  • 2 likes
  • 3 in conversation