I am trying to create a new Smartlist in GP using SQL tables from the DYNAMICS database. Most of our other Smartlists use tables from a different database that houses a lot of our GP data, but the tables I want to use are in DYNAMICS for this one.
When I go into Smartlist Builder and try to add a SQL Table, when I choose the DYNAMICS Database, there are no tables listed for it to choose from.
I think this is a security/permissions problem with DYNAMICS?