• OldFartPhil@lemm.ee
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year 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
      2
      arrow-down
      1
      ·
      1 year 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@lemm.ee
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

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