How to load a sqlite file into IRIS

Question

Question

Jayesh Gupta · Apr 2

I know that you can use Do $SYSTEM.SQL.Schema.ImportDDL() to insert sql files into IRIS however I was wondering if there is a way that I can upload .sqlite files into iris? I have about 20 .sqlite files that I need to get into my database. I tried using the ImportDDL method but it said "SKIPPING non-SQL SOURCE:"

Product version: IRIS 2023.3

Discussion (6)2

Log in or sign up to continue

score 0 · Answer 1 · 2024-04-02T10:31:36-04:00

Three options come to my mind:

1) export to CVS and use IRIS import

2) use sqlite JDBC

3) use sqllite ODBC

Using 2 or 3 you can import data and definitions directly

score 0 · Answer 2 · 2024-04-02T10:36:27-04:00

thanks for the prompt response, i was under the impression for 2 and 3 that I need to setup a database first then use jdbc to connect it iris. However, if I want to just import .sqlite files into iris, can I use both methods 2 and 3 without setting up a database with said .sqlite files

score 0 · Answer 3 · 2024-04-02T10:54:50-04:00

Enrico Parisi · Apr 2

For 2 & 3 you setup IRIS to connect to sqlite via jdbc/odbc and then import data and definitions.

0 0

score 0 · Answer 4 · 2024-04-02T11:42:44-04:00

do i then also need to predefine tables in iris before i import data? i would ideally like to just have a .sqlite file that i can turn into a table with data

score 0 · Answer 5 · 2024-04-02T11:56:19-04:00

Once you have configured jdbc or odbc gateway to your sqllite DB, then the easier way is to use data migration wizard, from Magegement Portal:

System Explorer -> SQL, then Wizards -> Data Migration

"The Data Migration Wizard will help you copy SQL table definitions and data by using your defined SQL Gateway connections."

score 0 · Answer 6 · 2024-04-02T12:07:53-04:00

there is an example in OEX
https://openexchange.intersystems.com/package/db-migration-using-SQLgateway

It's for PostgreSQL but the difference is only the specific jdbc used