[midPoint] Database table connector to MS SQL

[dmitri at asgardsecurity.eu]

Hello!

 �

I have a MS SQL with View, accessible with SQL Management Studio, all ok.

Now I’ve used next configuration to setup the resource in Midpoint:

 �

<connectorRef oid="88cd0194-1ace-4d17-a613-14edd35dc292" relation="org:default" type="c:ConnectorType">

        <!-- ConnId org.identityconnectors.databasetable.DatabaseTableConnector v1.4.9.1 -->

</connectorRef>

<connectorConfiguration xmlns:icfc=http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/connector-schema-3>

        <icfc:configurationProperties>

            <icscdbtable:host>XXX.com</icscdbtable:host>

            <icscdbtable:port>1433</icscdbtable:port>

            <icscdbtable:user>XXX </icscdbtable:user>

            <icscdbtable:password>

                <t:encryptedData>

                    <t:encryptionMethod>

                        <t:algorithm xmlns=http://prism.evolveum.com/xml/ns/public/types-3>http://www.w3.org/2001/04/xmlenc#aes256-cbc <http://www.w3.org/2001/04/xmlenc#aes256-cbc</t:algorithm> </t:algorithm>

                    </t:encryptionMethod>

                    <t:keyInfo>

                        <t:keyName>XXXXX</t:keyName>

                    </t:keyInfo>

                    <t:cipherData>

                        <t:cipherValue>XXX</t:cipherValue>

                    </t:cipherData>

                </t:encryptedData>

            </icscdbtable:password>

            <icscdbtable:database>XXXX</icscdbtable:database>

            <icscdbtable:table>Profiles</icscdbtable:table>

            <icscdbtable:keyColumn>Staff Id</icscdbtable:keyColumn>

            <icscdbtable:jdbcDriver>com.microsoft.sqlserver.jdbc.SQLServerDriver</icscdbtable:jdbcDriver>

            <icscdbtable:quoting>Single</icscdbtable:quoting>

            <icscdbtable:jdbcUrlTemplate>jdbc:sqlserver://%h:%p;encrypt=false;databaseName=%d;</icscdbtable:jdbcUrlTemplate>

        </icfc:configurationProperties>

</connectorConfiguration>

 �

 �

Test Connection is ok, schema generation is ok – everything seems to be fine, now when I try to browse objects from resource or run import task I get exception: 

Operation

org.identityconnectors.framework.api.ConnectorFacade.search

Message

Configuration error: SQL param name should be not null

Parameters

objectClass

[ObjectClass: __ACCOUNT__]

  

	
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20221011/a048eb61/attachment.htm>