I'm having some difficulty building a Report Definition to make a simple database query. I understand how to build the query, but I don't see how to set the database or table to do the query in. It seems like it should be in the Data Access Tab, but I don't want to do a join. I have some database connections set up using Connect-SQL but I'm having difficulty making a similar query as a Report Definition. Any help?
If you want to use Report Definition you should do the database table mapping to the db table of the class you implement the RD in. Connect-SQL and Report Definitions are used for different purposes:
You need to use Connect-SQL rules, if you have data in external tables, and no data table class mapping is already done. Also you might have complex structure of data to be best retireved through queries/stored procedures only. Connect SQL is idle for your business data which in general scenario will reside under different database and your Pega DB is different
Report Definition is idle when you mostly needs your process(flow/work object) data and underlying properties to query are already optimized for reporting. However report definition can also include business data if underlying database table are already mapped to pega data classes.