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



    • Related Articles

    • Downloading and Installing Intelligence Reporting

      1. Download Intelligence Reporting To download your version of Sage Intelligence, visit our website and choose the appropriate version. a) Visit our website here: https://www.alchemex.com.au/intelligence-reporting/#alchemextrial b) Choose the ...

    • Sharing Report Shortcuts using Intelligence Reporting

      Problem When you create a report shortcut, it creates and points to a file within the AppData directory of the user that created the shortcut, which in turn points to the BICore.exe on the machine. When another user tries to run the report shortcut, ...

    • Does Intelligence Reporting and CData support TLS 1.2?

      Question A recent upgrade from Microsoft has marked End of Life for TLS 1.0 and 1.1. I am using Intelligence Reporting and/or Cdata drivers selled by Alchemex and need to upgrade my servers. How will it affect my Reporting? Support for Intelligence ...

    • Error 1603 during installation

      Error 1603 occurs at times on installation and there are many potential causes that need to be eliminated. Message Received Windows Installer installed the product. roduct Name: Velixo Reports Pro for Excel and MYOB Advanced 4.0.0.22139. Product ...

    • .Net Installation Error on Windows 10

      Problem: You are running into an error when you are trying to install the Intelligence Reporting product onto a Windows 8 or 10 workstation.   Resolution: Open the Control Panel and go to Programs and Features Select Turn Windows Features on or off ...