Database Connection
Database connections ..
Last updated
Was this helpful?
Database connections ..
Last updated
Was this helpful?
Connect to the data source.
Overview of Steel Wheels Database
Connect to Sampledata DB with a DB Management Tool
Connect to Sampledata with Data Integration
Ensure you have downloaded the supported JDBC driver.
Copy the driver in the /lib directory.
Reboot to register the driver.
In Spoon, click File > New > Transformation.
Any one of these actions opens a new Transformation tab for you to begin designing your transformation.
By clicking New, then Transformation
By using the CTRL-N hot key
This section is for reference only.
The Container has already been deployed and is exposed on port: 3306
Ensure Docker Desktop is up and running.
In Docker Desktop Terminal, create a MariaDB directory & copy compose.yml.
Execute compose.yml.
Check the Container is up and running in Docker.
You can also check in Visual Studio Code
Open VSCode: C:\Workshop--Data-Integration\Scripts\sampledata_mysql.sql
Copy & paste sections of the script into DBeaver SQL script & execute.
Just double check that the tables have been created and populated.