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,

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.

Thanks Tamra for your response

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

Thanks

Hi Tamra,

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

Thanks
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

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.

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.

Thanks Clif and dbeagan !!

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

Please help me on this.

Thanks
Neelima

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

Thanks Tamra!!!

Its work for me.