Question Re: Conenction to SQLITE in Technology Q&A

Conenction to SQLITE

Phani_Kumar — Mon, 27 Jul 2020 09:29:55 GMT

Hello ,

I am trying to connect to SQL DB and But I can't see "Connect" Option here in SQL Tools to add a value . Do I have to install any plugins?

Re: Conenction to SQLITE

SebastianEsch — Mon, 27 Jul 2020 10:13:45 GMT

Hi Pawan,

I guess from the screenshot that you are using SAP Business Application Studio?

On the right in the list of connections, click on "No Connections. Click here to add one". Then select "SQLite (Node native)". Insert a connection name and the path to the database file. Unfortunately the "Select File" button opens a File Dalog, where you can choose from your local disk and not from the disk of Business Application Studio. You can work around that issue by looking for the path to the SQLite DB file in the terminal and copy & past the path to the database file field.

Kind regards,

Sebastian

Re: Conenction to SQLITE

Phani_Kumar — Mon, 27 Jul 2020 10:40:08 GMT

Hi sebastian.esch

Posted on

Thanks for your answer... Yes I am inside Business Stuido in my SCP Trial Version.

As I cannot add a DB File, I tried to add through the below path to add the file path to SQLITE.DB .But Inorder to add file , I should have connections inside SQLTools. But I don't see that option. I would request you to tell me how will I get that option or how to connect to my SQLITE.DB

Re: Conenction to SQLITE

SebastianEsch — Mon, 27 Jul 2020 17:38:13 GMT

Hi Pawan,

you need to know the path of your SQLite db file in Business Application Studio. You can open a terminal in BAS and navigate to the folder, where your db file is located and type pwd, this prints the current working directory. Combine that with the file name.

In my screenshot it is /home/user/projects/demo for the folder and sqlite.db for the db file.

Then click into the Database File field in your screenshot named "first" and paste there. That's it. You have to add Connection Name as well, but then you can save the connection.

Kind regards,

Sebastian