SQLite Connector Setup

Version 23.0.8517

SQLite Connector Setup

The SQLite connector allows you to integrate SQLite into your data flow by pushing or pulling data from SQLite. Follow the steps below to connect CData Arc to SQLite.

Connect a Database

The SQLite connector reads data from local database (.db) files. You can direct the connector to these files from either the connector configuration pane or the Connections tab of the Settings page.

From the Connector Configuration Pane

  1. Drag the SQLite connector into an Arc flow and give it a name.

  2. In the Connector Configuration pane, click + Create next to the Connection drop-down list.

  3. The Add Connection modal appears. Provide the requested information:

    • Name — The static name of the connection. Set this as desired.
    • Type — This is always set to SQLite.
    • Data Source — The local file path to the database file. For example, C:\ProgramData\CData\Arc\db\app_logs.db.
  4. If needed, click Advanced to open the drop-down menu of advanced connection settings. These should not be needed in most cases.

  5. Click Test Connection to ensure that Arc can reach the specified file. If an error occurs, check the path and folder permissions.

  6. Click + Add Connection to finalize the connection.

  7. In the Connection drop-down list of the connector configuration pane, select the newly-created connection.

  8. Click Save Changes.

From the Settings Page

  1. Open the Settings page, and then click the Connections tab.

  2. Click + Add to open the Connection Type modal.

  3. Click SQLite, then click Next.

  4. Continue from step 3 above for Connection Configuration Pane.

Select an Action

After establishing a connection to SQLite, you must choose the action that the SQLite connector will perform. The table below outlines each action and where it belongs in an Arc flow.

Action Description Position in Flow
Upsert Inserts or updates SQLite data. By default, if a record already exists in SQLite, an update is performed on the existing data in SQLite using the values provided from the input. End
Lookup Retrieves a value from SQLite and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from SQLite. It should be formatted as a SQL query against the SQLite tables.
Select Retrieves data from SQLite and brings it into Arc.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
Execute Stored Procedures Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.