Is there a way to add conditions on Database profile I it has for XML profile through filters ?
Better you can write those conditions in the query instead of applying in DB profile.
When we try to create a DB profile, we get option to set parameters which you can pass the value while configuring the db connector.
When extracting data from a database, you can use only a single query. However, that query can join multiple tables and perform other filtering logic.
Here are some suggestions for integrating databases:
Refer to the documentation provided by your database vendor for syntax details as SQL syntax differs between database vendors. For example, Oracle's SQL syntax is slightly different from Microsoft SQL Server's syntax. Your SQL statements will be parsed by the database you are connecting to.
Understand table schemas, relationships, and key fields.
Develop and test queries using a SQL tool like Query Analyzer or SQuirreL. These tools give fast and easily readable results.
I am new to Boomi and let me know in case i was right or wrong about it.
Retrieving data ...