0
Answered

SQL Connector/Adapter

Daniel Walters 1 month ago • updated by Adam van Vliet (Chief Information Security Officer) 2 weeks ago 8

I haven't worked with UNIFYBroker in some time. I've got a SQL Connector/Adapter here and I'm looking for the table that it's connecting to. The agent has a connection string in it that specifies the server and the database but not the table name and the connector doesn't contain the table name either. I can see when I create a new connector I can choose a schema provider. Can you explain how a connector knows which table it is connecting to or does it pool all the attributes from all tables in the database - I thought that's what an adapters do. There's no UNIFYBroker\SQL category so I've left uncategorized.

Affected Versions:
Fixed by Version:

Answer

Answer

You can also get back to that view by editing the connector, however the table name should be visible on the connector details page.

The table name should also definitely be in the extensibility file and should look like this:

<Extended>
    <communicator owner="dbo" table="mytable" readThreshold="1000" />
</Extended>

If this isn't the case, can you provide screenshots and the extensibility file?

Under review

Hi Daniel

The database connector does contain a Table configuration item. See the screenshot and field descriptions on the Database Connector page, does your connector appear different to this?

It seems that that view is available only on the creation of a connector but I can't see a way to view which table an existing connector is connecting to. I checked the extensibility file also and couldn't find any reference to a table name.

Answer

You can also get back to that view by editing the connector, however the table name should be visible on the connector details page.

The table name should also definitely be in the extensibility file and should look like this:

<Extended>
    <communicator owner="dbo" table="mytable" readThreshold="1000" />
</Extended>

If this isn't the case, can you provide screenshots and the extensibility file?

Hi Daniel, did you find the information you were looking for?

We're working through a few things so I'll get the screenshots next chance I get.

Hey Daniel,

Have you had a chance to get some screenshots?