When to use this connector
Create a connection to a temporary, in-memory database and use it as a staging area for the data.
You can also use it to execute complex JOINS and Set operations across heterogeneous data sources.
The SQLite engine is used for temporary databases.
The objects in a temporary database, such as tables, views, etc., are only visible to the database connection that originally created them and are automatically deleted when the connection that created them closes.
Creating a connection
To create a connection to a temporary database:
Step 1. In the Connections window click the
+ button and type in
Step 2. Enter the required parameters.