Smart Connector Microsoft SQL Database Integration

[huynhngochoi]

Hi everybody,
I am having a problem, I have configured it according to the instruction file (attached file). However, I am not getting any variables on the EBO side.
Has anyone encountered this error?

[PiotrJakubczyk · Accepted solution]

Hi @huynhngochoi 

Did you try to go to System/Hardware/EcoStruxure Web Services and right click and "Host EWS Object"?

https://ecostruxure-building-help.se.com/bms/Topics/show.castle?id=8766&locale=en-US&productversion=...

[huynhngochoi]

Hi @PiotrJakubczyk ,

I did as you said but I still don't get the values I wanted

[PiotrJakubczyk]

@huynhngochoi 

There were also other problems? What was your solution? Probably you need to go into smartconnector Setup and configure Logging

SmartConnector provides the ability to configure different logging levels and different log categories. While the logging features can be very helpful to debug any issues, there are some log level and category combinations that could represent a security vulnerability.

Specifically, the use of “All”, “Debug”, or “Trace” log levels along with logging for the Portal and API will cause unencrypted processor configuration values to be stored in the log file. Thus, it is recommended to not operate at “All” or “Debug” log levels unless necessary to trace a problem.

All SmartConnector logs are written to the “%PROGRAMDATA%\SmartConnector\Logs”

[huynhngochoi]

Hi @PiotrJakubczyk ,

I don't see anything other problem
First I delete all Processor & EWS Servers, then add them again and Host EWS Object as you said.