Installation of MYOB Live Intelligence Reporting (ODBCLink)

Installation of MYOB Live Intelligence Reporting (ODBCLink)


How the product works
  1. We install a few products below that all work together to make a replication of your MYOBLive database on a local installation.
  2. The product that is doing the work is called ODBCLink which connects directly to MYOB live and delivers information to a database specified within the application itself.
  3. Sage Intelligence Reporting then reports off that database.
Before we start - some Frequently Asked Questions
  1. Do I need to be a technical person or computer savvy to complete this installation? If you are not a technical person, please forward this onto your IT provider and they can do this for you.
  2. How often does my MYOBLive information update? We schedule ODBCLink to update the database at either a time specified by the customer, or on a scheduled basis using the Windows Task Manager
  3. Where should the SQL Server be installed? It can be installed anywhere on the domain. If all users who will be running Sage Intelligence have access to the SQL server, it means that only one ODBCLink License will be required and you will only need to purchase additional users for the Reporting modules.
  4. How often do I need to authenticate my username and password for MYOBLive? We will need you to authenticate the application during set up, and following that it should have no problems connecting directly through the API's.
  5. Which computer do I install ODBCLink on? ODBCLink will only need to be installed on a workstation that can connect to the SQL Server

It will take approximately 1 hour to connect the software to one MYOB Live company, assuming the below products have been installed already or the connection details have been supplied. Without the below being downloaded and installed, it may take up to 3 hours for installation.

Configuration Checklist - For More information on Default Configuration, see below
  1. Domain Administrator Credentials or Access Level
  2. Download and install Sage Intelligence Reporting v7.5 from this link using default parameters.
  3. Download and install ODBCLink from this link using default parameters.

    1. If you do not have SQL Server installed - Download and install SQL Server express from here
    2. If you do have SQL Server installed - Provide SQL server instance, SQL username and SQL password
  5. Download and install SQL Server Management Tools from here