A temporary (staging) database connector

When to use this connector

Create a Connection to a temporary, in-memory database and use it as a staging database 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 is closed.

Create a Connection

To create a Connection to a temporary database:

Step 1. In the Connections window, click +, and type in temp. Select Temporary Database.

Step 2. Enter the required parameters.