• BoofStroke
    link
    fedilink
    English
    arrow-up
    5
    ·
    8 months ago

    IT isn’t developers. What is really needed is a developer on your team, or somebody who at least knows how to lead the effort. I’ve been that guy.

    • OldFartPhil
      link
      fedilink
      English
      arrow-up
      2
      ·
      8 months ago

      We do have developers on our team. They write Excel macros :). I work in data integration, so it isn’t as simple as building a more robust tool. We still need infrastructure support or our tool doesn’t do anything.

      • Melkath@kbin.social
        link
        fedilink
        arrow-up
        3
        arrow-down
        1
        ·
        8 months ago

        Please at least tell me that the Macros are just a front end for ODBC connections to actual SQL servers for ETL functions, and it ALL isn’t stored only in excel…?

        • OldFartPhil
          link
          fedilink
          English
          arrow-up
          2
          ·
          8 months ago

          It’s not that bad, the macros are just front end apps. Our data is housed in a real, enterprise class database.