10.3.2 Connecting Excel Desktop version to FactoryWiz

10.3.2 Connecting Excel Desktop version to FactoryWiz

Before attempting to connect Excel to FactoryWiz database, you must install the ODBC connector.
See ODBC Installation
  1. Open Excel and create a new Workbook
  2. Select DATA Tab and then select From Other Sources > From Data Connection Wizard

  3. Then select ODBC DSN and click the Next button

  4. Then select your previously configured CyclesDB data source from the list and click the Next button

  5. Then you can select a single table from the list and click Finish, or you can uncheck the Connect to a specific table option and click the Next button
  6. Select your prefered Save Data Connection options and click Finish

  7. If you unchecked the Connect to a specific table option in step 5, then you will have the option to select multiple tables by checking the Enable selection of multiple tables option in this step of the Wizard
    If so, select the desired tables and then click the OK button (You must select at least one table to enable the OK button)

  8. Now select your Import Data options and click the OK button
Now that your data is loaded, you can work with the data to analyze, create reports, etc.
You can also use Excel macros to dynamically access the data. 


    • Related Articles

    • 10.3.1 Connecting Excel with Office365 to FactoryWiz

      Before attempting to connect Excel to FactoryWiz database, you must install the ODBC connector. See ODBC Installation 1. Open Excel and create a new Workbook 2. Select DATA Tab and then select Get Data > From Other Sources > From ODBC 3. Select ...

    • Preparing for FactoryWiz Monitoring

      Preparing for FactoryWiz Monitoring FactoryWiz Installation This document is to help you understand the preparation which is required to ensure that your system deployment goes as smoothly as possible. We want to make sure that you have a good ...

    • 10.3.3 Sample Excel Workbook using FactoryWiz data

      Click this link to download an example Excel Workbook showcasing the types of views that are possible using ODBC Connector in Excel After you download the Excel, you should check to make sure it does not have "the mark of the web", meaning it may ...

    • 1.1 Accessing FactoryWiz

      FactoryWiz is viewed and accessed using a web browser. Enter the server name (or IP address) of the FactoryWiz server into the web browser address bar. Figure 1‑1 Login Window To access FactoryWiz, the device you are using will need to be on the same ...

    • FactoryWiz ERP Integration

      FactoryWiz is an open system, meaning it provides opportunities for bidirectional communication with other systems. In the FactoryWiz manual there is a Data Dictionary section which highlight the data you will want to capture, as well as Data ...