connecting to commercial software

  • Hello,

    I want to use an SQL Server database to connect to our commercial accounting software overnight and take a snapshot of the data.

    This will be used to run stored procs and save "extracts" as Excel files for people to use for various reporting the next day.

    Firstly, is this possible!!!

    Secondly, would anyone be able to give me any tips/advice about how to get started with this exercise or where I can find online resources to help with this.

    As always, I appreciate your help

    Phil

  • I would think you'd need to provide more specifics about the software & platform to get much of an answer.

  • Agreed, more details will yield a better answer. It will depend on accounting software and the software platform.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply