🚀 go-pugleaf

>I had started looking at adobe products as a way to do this and was beginning to get the impression I could use various adobe products for the whole thing.

Ah, that's (probably) true.  Though database publishing is a fairly
specialist area, and if that is the main emphasis it may be worth
looking for specialist tools. For instance there is (or was) a Ventura
Database publisher. Or...
>
>It looks like ADBC or Indesign-datamerge can get at the data, then I needed to find an adobe product to create the brochure using templates and allow the layout changes/formatting.

If merging in InDesign, you would need, and could use, InDesign. If
merging in Acrobat (doesn't ADBC imply Acrobat?), you would need
Acrobat Professional PLUS something for the original design - which
would be purely visual and could be InDesign, Publisher etc.

 Then create the pdf per above...

> acrobat 6 standard to write the pdf.

There's no ability to create processes with ADBC in Acrobat Standard,
though it supports it in scripts made with Professional.

Aandi Inston