Need to extract all queries used in our SQL Server connectors.

Options
jimsteph
jimsteph Contributor
in Connectors

We recently realized that someone in the past hard-coded database names — names which have since changed — in some of the SQL queries used in the SQL Server connectors. Unfortunately, we have hundreds of connectors, and opening up each of them manually to look for a problem will not be fun. To avoid doing that I want a way to bulk extract the SQL from all of these connectors to a file or dataset that we could then look through. I looked in DomoStats to see if maybe this was available in an XML field, but couldn't find anything close. Is there any way to do this?

Tagged:

Answers

  • Haloupek
    Haloupek Member
    Options

    I agree this would be very, very helpful.

  • RobB
    RobB Contributor
    Options

    I'm going to see if there's a way to do this with the CLI. I don't think it can do this, but I want to try some things and see. If not, I'm confident using either developer tools or Jupyter notebook integration could get us the detail. Would you like go down that path if possible?

  • jimsteph
    jimsteph Contributor
    Options

    I'm a novice with both, but I'm willing to learn, and I've got people here who could probably take it over if I get in over my head.

Categories