Aggregate Entitlement and Accounts from JDBC Source

[Bakhari (Bakhari Burrell)]

Here’s the blog post I wrote detailing what I did. Thanks!

Edit: Previous link no longer works. Here’s the correct link:

Writing SQL Queries for JDBC Connectors

[header-image] The purpose of this blog is to demonstrate SQL queries that can be used to aggregate accounts and entitlements in a JDBC source connector. Finishing the setup of your JDBC database connector will require you to write a handful of SQL database queries, which will be discussed in this blog post. This article will include the following processes: Writing an Account Query Writing a Group Query Discovering Account Schema Creating the Entitlement Schema Aggregation Prerequisites …