Focal Point
[SOLVED] ODBC Data Connection to EDASEVE/ WebFOCUS Reporting Server

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7337048476

February 23, 2015, 08:03 AM
jimbo
[SOLVED] ODBC Data Connection to EDASEVE/ WebFOCUS Reporting Server
I have a somewhat convaluted ask from IT. I have a set of reporting marts built in predominantly XFOCUS & FOCUS running within our 7.7.03 environment. We have a larger dashboarding project underway where the new BI tool/presentation layer for the dashboard will be Tableau. one of the only key integrated data repositories are my XFOCUS / FOCUS marts. So out IT team would like to connect directly from Tableau via ODBC into these marts. I have seen an EDASERVE ODBC connector/driver (about 10 years ago) however I have no direct experience doing this. If anyone has an experience connecting from an ODBC client into the EDASERVE/WebFOCUS server any direction would be appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,


7.7.04
Win2K3, Unix
Oracle 10G,SQL2K,XFOCUS,ESRI,BID,MRE,SELF-SERVICCE
February 23, 2015, 09:20 AM
Alan B
There is not an ODBC driver available as an access method for FOCUS or XFOCUS data sources. WebFOCUS can use, as Tableau, ODBC drivers to access other data sources where there is a specific or generic driver available.


Alan.
WF 7.705/8.007
February 23, 2015, 10:02 AM
dhagen
There is 32 and 64 bit ODBC drivers available for 77 servers. I did a configuration early last year. Contact your local office - or CSS - as you may have to configure the server differently, and there may be licensing issues.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
February 23, 2015, 12:49 PM
jimbo
Thanks. That is what I remember being the case.


7.7.04
Win2K3, Unix
Oracle 10G,SQL2K,XFOCUS,ESRI,BID,MRE,SELF-SERVICCE