Menu
I'm looking for a tool that takes PostgreSQL tables and outputs a Data Dictionary in a wiki format (preferably Confluence). It seems like most tools out there require a lot of manual work/multiple tools to accomplish this task (IE> SchemaSpy, DB Visual Architect, Confluence plugins to take outputted HTML DD and convert to Confluence). I'm looking for ONE tool that will scan my Postgres tables and output a wiki friendly Data Dictionary that will allow seamless maintenance as the DB changes, without having to update my database and the DB schema in the other tool.
988
You can use SQL for Confluence to display and chart SQL query results by accessing multiple external data sources. You can show data as a table with all customization options available with Common table capabilities. With regards to editing the SQL data, you can use only use update and insert SQL.
You can connect Confluence to your database using a JDBC URL or a JNDI datasource. By default the setup wizard only provides the option to use a JDBC connection, as this is the recommended connection method.
By default, attachments, extensions, and configuration files are stored in the Confluence Home Directory that is configured when Confluence is first installed. All remaining data resides in the configured database.
Solution. If your confluence instance connects directly via JDBC, your database connection configuration is stored in <confluence_home>/confluence. cfg. xml file.
There is the Bob Swift's Confluence SQL Plugin that allows you to display data derived from a SQL query in a Confluence Page .. e.g. as a table .. perhaps it is worth a look for you?
Confluence versions 3.1.x - 4.9.x are currently supported...
The plugin is free and can be downloaded from Atlassian's Plugin Exchange: https://plugins.atlassian.com/plugins/org.swift.confluence.sql
Additional information about the plugin can be found here: https://studio.plugins.atlassian.com/wiki/display/SQL/Confluence+SQL+Plugin
175
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
