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