DataTalk supports reading data from various SQL databases
- PostgreSQL
- Microsoft SQL Server
- MySQL
- MongoDB
- MariaDB
- Oracle
Step 1: Database Configuration
Begin by entering the necessary connection details for your SQL database, such as the IP address, port, credentials, and other required information.
Step 2: Query Specification
Define a query (e.g., SELECT * FROM test_table;) to retrieve data from the database. DataTalk will use this query to fetch available tags from the specified table or dataset.
Step 3: Tag Selection
Once the query results are loaded, you can select specific tags you want to monitor. Additionally, ensure that a unique identifier is chosen to distinguish the entries effectively.
Step 4: Import Tags
The selected tags are then automatically imported into the tag database. You can test their functionality directly within DataTalk using the “Read” feature to confirm that the connection and data retrieval are working as expected.
This seamless integration allows you to efficiently connect and manage data from various SQL databases in your DataTalk projects.