Focal Point
[SOLVED]Derby Adapter

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/3227099286

July 05, 2016, 09:36 AM
Neelima
[SOLVED]Derby Adapter
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
July 06, 2016, 11:07 AM
Tamra
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
July 07, 2016, 03:36 AM
Neelima
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
July 08, 2016, 04:37 AM
Neelima
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
July 11, 2016, 04:00 AM
Neelima
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
July 12, 2016, 10:42 AM
Clif
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.
July 12, 2016, 07:29 PM
dbeagan
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.06
Win10 / IE11
AHTML EXL2K PDF
July 13, 2016, 09:38 AM
Neelima
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
July 25, 2016, 01:39 PM
Tamra
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
July 27, 2016, 04:02 AM
Neelima
Thanks Tamra!!!

Its work for me.


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