We are trying to use MirrorSync 1) for two way synchronization of FileMaker tables with tables in Oracle server, 2) for one way synchronization from a view in SQL Server to a table in FileMaker.

Trouble is, MirrorSync will not connect by JDBC to either Oracle or SQL Server. We are beginners in JDBC, and we sorely miss documentation for the topic:

What conditions have to be met by Oracle and by SQL Server for MirrorSync to be able to connect?

We are trying what we believe is the correct connect string(s) towards Oracle. SQL Server is set up to use Windows authentication (that is, accepting a login based on AD entities).

What documentation or other advice is available?

 

Update: We may seem to succeed with Oracle now. But SQL Server is still unsolved.

The article https://msdn.microsoft.com/en-us/library/ms378428%28v=sql.110%29.aspx shows syntax of connection URLs even for Windows integrated authentication - but to no use, as this field is not open for editing in the MirrorSync configuration dialogue for SQL Server. We have tried using the entry for JDBC Database, like this:

Description: JDBC Database SQL Server
Host: <name - single or fully qualified - or IP address>
JDBC Driver Class Name: com.prosc.mirror.model.CustomJDBCProperties <which it asked for until we provided it>
JDBC URL: jdbc:sqlserver://<host>:1433;integratedSecurity=true;authenticationScheme=JavaKerberos

Name and password should not be necessary for integrated security, and if we provide them, SQL Server logs error as "Login failed for user <username>. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only."

Without, we get error message that "The authentication Scheme JavaKerberos: is not valid" or without the javaKerberos clause, that "The property integratedSecurity does not contain a valid boolean value. Only true or false can be used." as if we didn't write "true" in the first place. What does MirrorSync want?

How do we know what JDBC driver Mirrorsync is using?

Edited May 4, 20169 yr by Jon Egil Brekke
New and relevant info

I think that MirrorSync is either using the 4.0.2 or 4.1 drivers from Microsoft. It's hard to tell because the jar files are all named the same thing, I'm just going by the release date of March 27, 2014.