Skip to Content
avatar image
Former Member

Business Objects connection to excel using JDBC

Because a jdbc connection can be created in the IDT and published it removes the need for command line access to the server to create a DSN . Does any one know how to set this up for jdbc i.e what jar file is needed , where does it need to be installed  and what does the connection string look like .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 01, 2015 at 02:35 PM

    Hi,

    JDBC connection is not supported with Excel data source in IDT.

    Please see section "SAP BusinessObjects BI Platform 4.1 Data Access" page number 20.

    Download the "Please consult the file Semantic Layer Datasources" file and you will get the idea about supported drivers for each data source.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/507d3365-009b-3010-04b0-e5abc8f00c91?QuickLink=index&…

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2015 at 09:12 AM
    Add comment
    10|10000 characters needed characters exceeded