I need to load a synonym table in sql server using dell boomi .Unable to import synonym table in database profile.How do we import synonym tables in dell boomi?
For Oracle databases, both tables and views are listed, synonyms not. But you can use them in your SQL select statement. It probably works the same with SQL server. That would be a nice addition because many systems use a lot of synonyms. And they should, it's a best practice
I have created an Idea:
Database profile import wizard: support for synonyms
Retrieving data ...