wbExport - JDBC source details

[Darshak]

Hi,

Is there way to add source JDBC details (e.g. JDBC URL) also in wbExport output (e.g. Excel, HTML) file ?

e.g.  -infoSheet parameter is to capture source SQL in case of -- ods, xslm, xls, xlsx

Purpose is to know source (track) env while looking at generated files of wbExport.

While working on multiple env. on daily basis, its very hard to recollect source env. info after few weeks / months for exported file. 

And JDBC URL  may change over period of time while regenerating files using wbExport.

Regards,

 Darshak

[Thomas Kellerer]

Well, the text/CSV format cannot store this information.

I would probably create a directory structure that resembles the source of each export e.g.

/export/production/2023-01-22/db1/table1.csv
/export/production/2023-01-22/db1/table2.csv

and so on.

The XML format contains this information by default in the header:

<generating-sql>.....</generating-sql>
<jdbc-driver>PostgreSQL JDBC Driver</jdbc-driver>
<jdbc-driver-version>42.3.1</jdbc-driver-version>
<jdbc-url>jdbc:postgresql://localhost:5432/postgres</jdbc-url>
<database-user>thomas</database-user>
<database-product-name>PostgreSQL</database-product-name>
<database-product-version>15.1</database-product-version>

Something like that could indeed be added to the infosheet.

Regards
Thomas

> --
> You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com <mailto:sql-workbenc...@googlegroups.com>.
> To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/ae18a99f-6f08-4295-ac00-05a829c6d45an%40googlegroups.com <https://groups.google.com/d/msgid/sql-workbench/ae18a99f-6f08-4295-ac00-05a829c6d45an%40googlegroups.com?utm_medium=email&utm_source=footer>.