Skip to main content

[Syniti Connect] Boomi Data Profile Generates Invalid SQL

Jenny Drummey
  • Updated

Syniti Connect uses the Stewardship Tier combined with Dell Boomi, an Integration Platform as a Service (IPaaS) solution. Boomi’s connectors allow the Stewardship Tier to extract and load data in systems that do not use a database connection, such as Workday, Salesforce or SAP SuccessFactors.

Issue

When using Syniti Connect, the Boomi Data Profile import process removes the brackets around field names, generating invalid SQL. 

For example, this valid SQL . .  . 

SELECT [/BEV1/LULEINH] FROM MARA

. . . becomes invalid when the Import modifies the statement:

SELECT /BEV1/LULEINH FROM MARA

Resolution

Editing the Select statement will not create or update the fields in the Profile. Update the invalid SQL following these steps: 

  1. Bring the SQL back into SSMS and add brackets around any columns that need them. Do not add any fields, remove any fields, or change the field order.

  2. Paste the SQL Statement back into the Edit SQL dialog.

  3. Save, Close, and Test.