Community
Question: Connectivity of Winccoa to Postgresql
Database Engineering Connectivity issue - we have enter database address (127.0.0.1:5432), which is of PostgreSQL
-we have created database in PostgreSQL, which is name as "newsql" and we Successfully established connection of ODBC
-but the main issue we are facing right now not able to establish connection to Winccoa to PostgreSQL we are mentioned all the required inputs correctly but not able to establish connection
-kindly help us this Particular issue. if any particular document or reference ticket are already generated , kindly provide us
Responses (3)
Which WinCC OA version are you using? 3.20 and 3.21 already use a WinCC OA managed PostgreSQL DB, which does this all on its own.
If you want to create the DB fully on your own, our online documentation should give you the needed steps to connect successfully: https://www.winccoa.com/documentation/WinCCOA/3.19/en_US/NGA/topics/nga_postgre_server_install.html
We are Using WinCC Oa version 3.21, We have already followed the referred link steps but connection is not established? so if possible there are any steps that directly connect to SQL which means establish connection between WinCC OA and SQL directly like WinCC Explorer also can you please guides how to connect WinCC OA to SQL and if there are any other reference link or documentation please provide us.
If you create the PostgreSQL database on your own you must use the WinCC OA scripts to create the correct schema in the database.
Have you executed the PowerShell scripts delivered with WinCC OA to create a PSQL database?
Have you configured the NGA backend in WinCC OA System Management?
Have you entered the correct database name + user credentials in WinCC OA System Management which fit your database?
Which errors do you get when the NGA Manager tries to connect to the database?
Best Regards
Leopold Knipp
Senior Support Specialist