How to load a sqlite file into IRIS
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
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
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
For 2 & 3 you setup IRIS to connect to sqlite via jdbc/odbc and then import data and definitions.
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
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."
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