Smart Connector Server and EBO connecting with SQL issues

[edgarquiroga_do]

Hello There, we have EBO 3.2 that we like to report in SQL and we still not make it. We follow some documents and videos and the last part for the connectorion we simply get lost, the main idea its to not use Report Server to have all the trends in SQL, so we are looking for the Smart Connector Server to Intagrate web services and SQL. We use https://www.smartconnectorserver.com/DownloadCenter/Contents/mongoose/v2.4 ver 2.4.40

If there is a guide step by step will be grate to use it and make it work. Attach its the Manual that we try to follow.

[MaximeLaudren]

Hello Edgar,

As far as I know, and understand this extension, it only provide capability to retrieve data from SQL DB to push it into EBO.

You cannot push data to a SQL server using this extension.

Max

[huynhngochoi]

Hi Sir,

Can you tell me where is this file (ISC.SqlReaderExtension.dll)? I have followed this this Manual but I can't see "ISC.SqlReaderExtension.dll" in "C:\Program Files (x86)\Schneider
Electric\SmartConnector".

[MaximeLaudren]

Hi,

Can you provide more details on what you try to achieve?

Why do you need this file for?
It might be part of a processor package.

Max

[SteveGregory]

If you install Web Reports, it installs a service that pushes extended log data to a SQL database that can be used with SQL Web Reports. You should follow the Web Reports installation guide which can be found on exchange. However, support for SQL Web reports is dropped in EBO 4.x / 2022. In EBO 5.x / 2023, support for SQL Databases for external log storage is introduced and is much easier to set up. It doesn't include support for integrated Web Reports into EBO, but you can still use SQL Web Reports on the SQL database that EBO will push the log data too. The custom extension that you are referring to is used to read data from a third-party SQL database and serve the data to EBO, so I don't think that is what you want.