Can you help me please how can I install pyodbc and the driver? If I good understand it should be installed into the HA virtual machine?
SQL Server connection can be working on a non-officially way?
Anyway there are no sulution in 2022 to connect to a simple SQL Server database? That is wierd for me.
A MySql or Sqlite tutorial would be also good if there are no chance with SQL Server. Thank you!
Not the database system is simple, but also the client connection. I “coming” from .NET world and a client connection and get data is a 5 minute task.
I collect measurement values from self-developed logger applications with lot of devices. All data stored in SQL server but I have no visual interface. So I would like show my logged data values in a visual interface like HA.
Since I don’t know HA well enough, I’m wondering what kind of custom data source can I implement?
Can I read data from Web API (I can create web api that reads data from SQL Server)? So can I use GET or POST request to show value in HA?
Of course. But you are far from .NET in the HA/Linux world…
If you have the choice, just go with MariaDB or PostgreSQL to make your live easier.
Those also have ODBC drivers, so, assuming your apps are written in .NET, should be painless.
Thank you I will try the Web API example, I think this will be the easiest solution.
Changing the database system is a bigger work (data migration, republish every software, create backup plans etc…)
# Loads default set of integrations. Do not remove.
default_config:
# Text to speech
tts:
- platform: google_translate
automation: !include automations.yaml
script: !include scripts.yaml
scene: !include scenes.yaml
sensor: !include sensors.yaml
The template:
{## Imitate available variables: ##}
{% set myJson1 = {
"randomValue": 54
} %}
{{ (myJson1.randomValue ) }}
After that I restart HA.
The sensor appear in the list, but the value is ‘unknown’ (The webapi produces a random int value).