When attempting to publish with Datamaker, it fails with the following error:
Error 1018 for Row #1 in table EventDetail. SQLSTATE = 37000
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.
The failing query:
INSERT INTO dbo.TestTable1 ( Id, Type, DateStamp, Transaction, EffectiveDate, Charge, Group, AccountID, Index) VALUES ( 5, 'onset', '2017-08-15 17:41:11.000', 'IssueAcct', '2017-08-16', '0', 'taDA2BB8ABC36C495A113350ATF42', '5168675309', 1)
Placing "Index" in brackets "[Index]" and testing that query manually works.
Using Portal and or Enterprise Publish from within Datamaker is successful. The problem is only present when publishing directly from Datamaker.