Please help me to connect ASA anywhere 11.0.0 to JDBC. I need to use SAP Lumira BI. They have to be connected via JDBC.

Please help me with step by step procedure.

Really appriciate.

asked 07 Apr, 07:44

hasan_pkb's gravatar image

hasan_pkb
11112
accept rate: 0%


There are two JDBC options that can be used - The SQL Anywhere JDBC driver which is not a pure java and jConnect which is pure-Java. To learn more, read SQL Anywhere JDBC driver.

permanent link

answered 07 Apr, 13:21

Chris%20Keating's gravatar image

Chris Keating
2.9k1650
accept rate: 28%

Thank you Chris,

I have read the link, but I still can not connect my ASA 11.0.0 to SAP Lumira (BI). SAP Lumira did not provide connection to ASA 11.0.0, So I choose JDBC Generic connection

Can you please kindly help me where to type:

  1. Path

set classpath=%classpath%;install-dir\java\jodbc.jar

  1. load driver

DriverManager.registerDriver( (Driver) Class.forName( "ianywhere.ml.jdbcodbc.jdbc3.IDriver").newInstance() );

  1. Suply a URL to the driver

Connection con = DriverManager.getConnection( "jdbc:ianywhere:DSN=SQL Anywhere 11 Demo" )

Please help me out...I can not upload any image, because my point is not enough.

Thank you very much for your reply..Really appriciate that..

Best regards,

Hasan

permanent link

answered 10 Apr, 02:37

hasan_pkb's gravatar image

hasan_pkb
11112
accept rate: 0%

I do not have any experience with SAP Lumina. But a quick web search shows that the generic driver setup is reasonably easy. It appears that you are prompted to supply the JAR file of the JDBC driver. You will also need the other supporting files in the path (i.e., the SA BIN32 or BIN64 drirectory depending on the bitness of the Java being used) if you are using the SQL Anywhere JDBC driver - it has native components. You will then see a dialog asking for the class and url which are described above.

You do not need a DSN so you can simple provide a connection string. If you are not sure how to setup a connection string, we can help with that on this forum. The basic premise is:

ENG=<your_db_engine_name>;DBN=<database_name>;UID=<user_id>;PWD=<password>

If you have not already started the database engine and database, you can add

DBF=<your_database_filepath>

This will autostart a standalone server.

If you have more specific questions about this, you will want to raise those in support or in the SAP Community Network for Lumina.

(10 Apr, 10:47) Chris Keating

See also Jason Hinsperger's answer here from today, it tells that SQL Anywhere is a pre-defined data source with Lumira...

(10 Apr, 11:06) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×67

question asked: 07 Apr, 07:44

question was seen: 344 times

last updated: 10 Apr, 11:28