How to open Microsoft Access database (.mdb) with Open Office Base

  • How to open Microsoft Access database (.mdb) with Open Office Base

    Below is a step by step instruction on opening up Microsoft Access *.mdb file by using free Open Office Base. It is screen shot basis and pretty much self-explained. First of all, launching Open Office Base shall prompt you with its wizard, choose ‘Connect to an existing database’, and scroll all the way up to […]

  • Moving A Table from MS Access to PostgreSQL

    The Microsoft Access database file (.mdb) that is located in the project folder is for testing purposes only. It can only hold not more than 2GB of data. In order to migrate the data stored in a MS Access to PostgreSQL, follow these steps below. First, open the Microsoft Access database file (.mdb). I will […]

  • Running Your Own MQTT Broker On Windows

    By default, the MQTT broker is included in the IntegraXor installer. To run your own MQTT broker locally on Windows, follow the steps below. Go to Start menu and look for Ecava IntegraXor Project Editor or Ecava IntegraXor SCADA Server, right-click on it and select Properties. The Properties menu will appear. Copy the Start in […]

  • Backup and Restore a PostgreSQL Database

    PostgreSQL is a open source object-relational database. We received many request from our clients asked us how to backup and restore a PostgreSQL database. Below are the steps to perform backup and restore of a PostgreSQL database with two simple steps.   Step 1: Backup the Database Follow the steps below to backup the database: […]

  • Splitting Workload Using Cluster Network

    Logging large number of tags at a time can increase the workload of the database. The increase of workload also increases the time required by the database to log all values at a time. In order to reduce the workload,  the Cluster Network will be used to split the task. Below is the system architecture […]

  • Setting Up a Cluster Network

    IGX Cluster Network module is designed for scaling and distributed configuration. The cluster module is divided into two parts; Cluster Master and Cluster Node. It is suitable for large scale projects with huge amount of IO tags by breaking down the tasks and distributing them across multiple nodes.  Part 1: Configuring the Cluster Master Firstly, […]

  • Setting Up MQTT

    This article will guide users on how to configure a MQTT Publisher and Subscriber using a public broker. It is divided into two parts; Part 1 and Part 2.   Part 1: Configuring the Publisher First of all, user need to enable the MQTT Publisher driver. Select IO Server on the left pane and enable the […]

  • Step-by-Step: How To Add and Link Multiple Database to Multiple Pages for Alarm Logging

    This article uses Microsoft Access database that comes with the Demo project. To setup PostgreSQL database for SCADA, refer to this article. In Project Editor, create two database and name it mdb_1 and mdb_2. Open project folder, make two copies of dblog.mdb and rename it to dblog_1.mdb and dblog_2.mdb. Copy the codes below and paste it in […]

  • Step-by-Step: Add Client To Active Directory Domain – Part 2

    This article will guide users on how to add a client to an Active Directory Domain Services. For server-sided configuration, see Part 1. Connect Client To Domain Open Network and Sharing Center. Click Change adapter settings on the left. Right-click on Local Area Connection, select Properties. In the Local Area Connection Properties window, select Internet […]

  • Step-by-Step: Setup and configure Active Directory Domain Services in Windows Server 2008 – Part 1

    In case you haven’t known, IGX allows you to use external user authentication system. So that you can administrate one user database for several systems from different vendors. Active Directory Domain Services developed by Microsoft is a directory service for the Windows domain networks. It turns the server into a domain controller which authenticates and […]

  • Enabling WEB SCADA interface for Wonderware

    It’s common to know that traditional SCADA can be very pricey when you need to add a little features here and there upon customers’ request. In case you need to work on any traditional SCADA and wish to incorporate some beautiful and affordable features in IGX, you could just use Web Client to house IGX […]

  • How to upgrade SCADA without disruption?

    Ecava IGX comes with two types of distribution, one is standard MSI installer, added since 2014 is another portable package which you can run out of the box. This mean you can unzip the distribution and carry around in your USB drive or access from virtually anywhere via fast network, as well as many many […]

  • How to calculate Moving Averages in SCADA?

    Mr. Wachira has recently asked how to do moving averages in SCADA, that made us recall how troublesome is to do some simple calculations in traditional SCADA. It can be even more painful when you need to deal with proprietary programming language. As such we are more than happy to share how elegant to calculate […]

  • SCADA Report with Selectable Column

    SCADA Report is good to have selectable column if you have long list of parameter logging, and when you want to do side by side comparison, or narrow down to small group of data for analysis. You can do this for your operator by adding a dropdown list of checkboxes and a standard script snippet. […]

  • Troubleshoot JavaScript in SCADA

    We highly recommend JavaScript as your scripting language despite Ecava IGX do support VB Script for awhile now. As compare to VB Script, JavaScript is the language of the web and for the future. JavaScript is powerful and flexible, but flexibility itself has pros and cons. JavaScript is very linient on syntax, for example it’s […]