Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report 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, 2009Report 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 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report 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 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report 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 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report 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.


N/A
 
Posts: 397 | Location: New York City | Registered: May 03, 2007Report 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.


WebFOCUS 8.2.06
 
Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010Report 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 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report 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, 2009Report This Post
Platinum Member
posted Hide Post
Thanks Tamra!!!

Its work for me.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
 
Posts: 186 | Location: INDIA | Registered: July 11, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders