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 CyclesDB and then click OK

7.    If you did not enter a specific database query in the previous step, then you will be presented with the ODBC Database Navigator, where you can select one or "multiple" items for your dataset. Select the table or tables that you would like to work with.

8.    Next, you can click the Load button to load the data and make it available to the Excel Workbook document, or you can choose Load To and select one of the options

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.2 Connecting Excel Desktop version to FactoryWiz

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

• 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 ...

• 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 ...

• FactoryWiz Monitoring License Install (Existing Customers / New License)

  Installing FactoryWiz Monitoring Licenses To install / download a new license sent from the FactoryWiz office, you will need to log into FactoryWiz with your admin credentials. Login as an admin Navigate to Licensing: CONFIGURATION > Licensing To ...

• 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 ...