Trying to use SSMS to connect to Domo Server via Domo ODBC Driver

I have configured the Domo ODBC driver and setup a DSN. I'm trying to establish a connection to the Domo Server so I can query multiple tables via SSMS.

My understanding is that this needs to be done through a linked server. However, I have not been successful getting the linked server to work.

Has anybody been able to connect to the Domo Server and query tables directly using SSMS? If so, can you share how you established the connection.

Regards,

Jack

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    @Jack_Kaye to be clear you're trying to query Domo, NOT query an on prem database?

    i'm sure it can be done but I'm not sure you're gonna get the desired end-user experience...

    Adrenaline wasn't really designed like Snowflake or TSQL in a cloud environment where you should be able to query the database with an IDE. The ODBC driver doesn't (AFAIK) get a lot of use so... i'm not sure how developed a feature it is.

    if it were me, I'd construct my query in Dataset Views in Domo and then just use literally any other (free) tool, Python + APIs or Domo CLI to export the data when i need it.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Thank you for your response. To clarify, I am trying to query the Domo Server/Database no an on prem database. I am able to use the Domo ODBC driver in DBeaver and I can query the Database/Tables easily. My reasoning for using SSMS is that I want to query both the Domo Database/Table and other tables from our on prem Server. An exampled would be wanting to query the Domo Dataset for our AR data and compare that to the AR data within our Financial Software's tables.

    I'm trying to avoid importing/exporting the data if possible. I can use SSMS to import the data from the Domo ODBC but that can be a problem with very large datasets and the data is outdated shortly after being imported.

    I was hoping there was a way to create a Linked Servers in SSMS using the Domo ODBC driver to allow me to directly query the Domo Server/Tables. Does this make sense?

    Regards,

    Jack