Skip to Content
0
Former Member
Jan 08, 2008 at 08:43 AM

Excel Import via JDBC

36 Views

Hi all,

i implemented the Hxtt driver but I still get "Connection fails" in the system landscape.

I did following steps:

In Visual Administrator:

1) JDBC Connector -> Drivers -> New Driver Excel_JDBC30 with Test_JDBC30.jar

2) Connector Container -> sap.com/com.sap.ip.bi.sdk.dac.connector.jdbc -> New clone of SDK-JDBC -> Resource Adapter -> library:Excel_JDBC30 was added

In Portal:

3) New System Excel_JDBC

4) Connection URL: jdbc:excel:/C:test_csv_jdbc.xls

5) Driver Class Name: com.hxtt.sql.excel.ExcelDriver

6) BI Directory Provider: yes

7) Factory Class: Excel_JDBC

8) User Mapping Type: admin,user

9) I created an alias: Excel_JDBC

10) Made user mapping for this system. Is it necessary?

Connection fails!!

Thank you for any help, best regards

Frank