How to write to SqLite ?

[Michael_S]

Hello everyone.
I'm posting this here because I found it somewhat hard to write to SqLite file databases.

Now I've figured out a way, it's working fine.

I'm not sure that it's the correct path, but I'm sharing my way  :

- drag an output data tool,
     - select options:
          File Format: "SQlite (*.sqlite)"
          Output Options: "Delete Data & Append"
          Pre Create SQL Statement: "CREATE TABLE IF NOT EXISTS Dim... "
     - name the file after the desired filename + PIPES + THE DESIRED TABLE NAME
          "OlympicMedals.sqlite|||DimAthlete"

- copy & paste the output tool, repeat the process for each table
     - adjust the pre create SQL code
     - change the table name after the pipes

thanks,

Michael.

[rkapoor · Accepted solution]

@Michael_S  this looks fine to me.