• DE
  • EN
  • FAQ
  • Download
  • Contact
  • Login
  • Account
  • Logout
  • Home
  • Functionality
    • The SQL4automation connector
    • Establish a database connection in 2 steps
    • Data management in the past and today
    • Connector & tools
    • Video Tutorial
  • Compatibility
    • Supported controllers
    • Supported databases
    • Supported MES
    • Supported platforms
  • License models
    • Software
    • Software & hardware
    • Download test version
    • Purchase/offer
  • Services
    • Commissioning
    • Consultation
    • Training courses
    • Support
  • References
  • News
  • FAQ
  • Download
  • Contact
  • Login
  • Account
  • Logout
  • DE
  • EN

How to set up a network between controller, Connector and database?

  • Can I write data to the controller from outside?
  • Why do I need more than one link?
  • How much does it cost?
  • Which databases can be use?
  • Which controllers can be use?
  • How does the demo version work?
  • How do I generate a SQL query in the controller?
  • SQL syntax
  • How long does a database query take?
  • How is the Connector licensed?
  • How to set up a network between controller, Connector and database?

The SQL4automation Connector is installed on a Windows or Linux PC. The database can be placed on the same PC, but this is not required. The Connector can be installed on a PC-based controller in the first place.

The communication between the controller and the Connector is handled via TCP/IP. Controller and Connector therefore need to be connected on the same Ethernet.

The communication between the SQL4automation Connector and the database is done via ODBC. Thus, Connector and database need to be connected through the same Ethernet as well. This is easily possible in a company network.

If the Connector is located on a PC with two network cards the communication can be set up to the controller through network 1 and to a database through network 2. Both networks have no physical interconnection, which is often required in company or machine networks.

  • Where do I get support?
download test version now

Inasoft Systems GmbH

Bahnhofstrasse 6, CH-3421 Lyssach
+41 34 445 20 10

ยป info@inasoft.ch

  • Concept & Design: smiroka
  • Programming: suxesiv
  • Data protection
  • Imprint
This website uses cookies to enable certain functions and to improve your user experience. By continuing to browse the site you are agreeing to our use of cookies. More Information OK