Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Derby Adapter
 Login/Join
 
Platinum Member
posted
Hi all,

Can I create an adapter for derby database. if yes, what steps and addition resource I need for same.

Thanks

This message has been edited. Last edited by: Neelima,


WebFocus 7.7.02,7.7.03,8.0,8103,8105
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 157 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
Hi Neelima,

Please review the following found on the IBI Technical Support Center Knowledge base:

Why is the Derby Adapter not in the WebFOCUS Adapter list
How to set the JDBC adapter for Derby to Read Only.


Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator - Information Builders Inc.


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Tamra for your response

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

Thanks


WebFocus 7.7.02,7.7.03,8.0,8103,8105
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 157 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Tamra,

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

Thanks
Neelima


WebFocus 7.7.02,7.7.03,8.0,8103,8105
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 157 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 7.7.02,7.7.03,8.0,8103,8105
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 157 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
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.
 
Posts: 333 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WF 8.2.01
Win10 / IE11
AHTML EXL2K PDF COMT WP ZIP
 
Posts: 103 | Registered: October 19, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Clif and dbeagan !!

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

Please help me on this.

Thanks
Neelima


WebFocus 7.7.02,7.7.03,8.0,8103,8105
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 157 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
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, 2009Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Tamra!!!

Its work for me.


WebFocus 7.7.02,7.7.03,8.0,8103,8105
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 157 | Location: INDIA | Registered: July 11, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2017 Information Builders, leaders in enterprise business intelligence.