BRW and SQL tables (OpenInsight 64-bit) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

{{tag>category:"OpenInsight 64-bit" author:"Karl Pozmann" author:"bob carten"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== BRW and SQL tables (OpenInsight 64-bit) ====
=== At 03 DEC 2021 07:51:32AM Karl Pozmann wrote: ===
 
 
<QUOTE>
Is it possible to use the BRW with SQL tables?  Specifically DB2....
</QUOTE>
----

=== At 03 DEC 2021 08:33AM bob carten wrote:  ===

<QUOTE>

It's possible to use the SQL connector to connect to connect to DB2 using a db2 odbc driver, and then to use the BRW against the resulting table.  However, unless you have a simple single table report I think it would would be easier to use a reporting tool like FineReport or Microsoft Power Bi

</QUOTE>

----

=== At 03 DEC 2021 09:54AM Karl Pozmann wrote:  ===

<QUOTE>Thanks - I think I'll have to go with one of the ones you recommended....

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=67E7AEA857E36B478A2C980D42B731FA|View this thread on the Works forum...]]