[SOLVED]Derby Adapter

Platinum Member

posted

Thanks Tamra for your response

I am not able to open given link its asking for credentials.

Thanks

WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies

Posts: 186 | Location: INDIA | Registered: July 11, 2013

Ignored post by Neelima posted

Platinum Member

posted

Hi Tamra,

Could please let know how can I get all configured adapter list from server.

Thanks
Neelima

WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies

Posts: 186 | Location: INDIA | Registered: July 11, 2013

Ignored post by Neelima posted

Platinum Member

posted

Hi All,

I have tried to search all configured list of Adapter in Server directory but did not get any success.

Somewhere, I read that in edasprof.prf file content all the configured adapter info. but i couldn't see in my server directory.

Please guide me.

Thanks
Neelima

WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies

Posts: 186 | Location: INDIA | Registered: July 11, 2013

Ignored post by Neelima posted

Clif

Guru

posted

While there is no "named" adapter for Derby you can access it using the generic JDBC adapter. You can find documentation in the Adapter Administration manual in the section Using the Adapter for JDBC. The only additional resource you need is the Derby JDBC driver in your classpath.

You can see a list of configured adapters from the Web Console on the Adapters tab in the Configured folder. You can also right click on Adapters and select "Complete Adapters List" to see that report.

N/A

Posts: 397 | Location: New York City | Registered: May 03, 2007

Ignored post by Clif posted

dbeagan

Platinum Member

posted

Here are my notes from the last time I configured this. Be aware, these are the settings for my environment, yours man be different. I hope this helps you. To configure adapter to Derby:

  
1. In the WebFOCUS Administration Console, note the values under Configuration | Application Settings | Repository:
  
2. In Reporting Server Console, add adapter: 
Adapters | Available | SQL | JDBC Generic
Right-click JDBC Generic and select Configure

3. Enter values for 
  Connection Name	derbycon01
  URL			jdbc:derby://127.0.0.1:1527/WebFOCUS80;create=true
  Driver Name		org.apache.derby.jdbc.ClientDriver
  IBI_CLASSPATH	        C:\ibi\derby\lib
			C:\ibi\derby\lib\derbyclient.jar
                        USERID:  webfocus
                        Password: **********

4. Click Configure

5. Configuration then appears under Adapters | Configured | JDBC Generic
Right-click on the connection name and select Properties
Click Test button, should see a list of tables.

WebFOCUS 8.2.06

Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010

Ignored post by dbeagan posted

Platinum Member

posted

Thanks Clif and dbeagan !!

I want to get the list of configured Adapter from server.

Please help me on this.

Thanks
Neelima

WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies

Posts: 186 | Location: INDIA | Registered: July 11, 2013

Ignored post by Neelima posted

Tamra

Guru

posted

Neelima,

On the Reporting Server:
If an adapter has already been configured, it is listed in the Configured folder of the Adapters page navigation pane.

Most of the adapter configuration information is contained in two configuration files, EDASPROF.PRF and EDASERVE.CFG.
◾EDASPROF.PRF, or the global profile, contains data adapter connection information.
◾EDASERVE.CFG contains database release and access method information.

Hope this helps you out.
Tamra

WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5

Posts: 487 | Location: Toronto | Registered: June 23, 2009

Ignored post by Tamra posted

Platinum Member

posted