TERADATA SOURCE AND SINK CONNECTOR
If you have Vmware Player or Workstation, you can import this virtual machine and use it immediately.
If you don’t have Vmware Player or Workstation, or prefer to use VirtualBox, you can complete the following steps:
Open VirtualBox and create a new virtual machine.
Name the virtual machine, set the type to Linux, and version to openSUSE (64-bit). Click “Continue”.
Linux
openSUSE (64-bit)
Set the virtual machine to a minimum of 4096MB of memory. Click “Continue”.
Select “Do not add a virtual hard disk”, and click “Create”.
A warning will pop up about creating a virtual machine without a hard disk. Click “Continue”.
Select your newly created virtual machine, and open “Settings”.
In the “Storage” tab, select the “Controller: IDE”, and add a hard disk.
For each of the three extracted disk files (with .vmdk file extension), do the following:
Once you’ve added all three virtual hard disks, choose the “Network” tab.
Open the Advanced settings, and click on “Port Forwarding”.
Add a new port forward for the database connection
1025
Optionally, add a port forward for SSH access
2222
22
Note
You will be able to SSH into the running machine with ssh root@localhost -p 2222 with password root.
ssh root@localhost -p 2222
root
Click “OK” to exit the port forwarding window, and Click “OK” to exit the settings window.
Click “Start” to start up your virtual machine. Startup typically takes 2-5 minutes, and database startup continues after the machine first becomes usable via terminal.
You can now proceed with the remainder of the quickstart, with the database running in the background.
In your Teradata VM (or over SSH), start BTEQ and log in:
bteq .logon dbc dbc
Your output should resemble:
BTEQ 16.20.00.04 Tue Nov 5 18:03:15 2019 PID: 10393 +---------+---------+---------+---------+---------+---------+---------+---- .logon dbc *** Logon successfully completed. *** Teradata Database Release is 16.20.32.01 *** Teradata Database Version is 16.20.32.01 *** Transaction Semantics are BTET. *** Session Character Set Name is 'ASCII'. *** Total elapsed time was 1 second.
In the BTEQ command prompt, create another user dev with password dev and give them access to their database dev.
dev
CREATE USER dev AS PERM = 1000000000 BYTES PASSWORD = dev; GRANT ALL ON dev TO dev;
CREATE USER dev AS PERM = 10000000 BYTES PASSWORD = dev; *** User has been created. *** Total elapsed time was 1 second. GRANT ALL ON dev TO dev; *** Grant accepted. *** Total elapsed time was 1 second.
Quit BTEQ:
.quit
.quit *** You are now logged off from the DBC. *** Exiting BTEQ... *** RC (return code) = 0
When it’s time to shut down, you should stop the database gracefully, and power-off the VM:
Open the VM window, or SSH into the machine. You will need a root prompt to shut off the system.
Stop the database
/etc/init.d/tpa stop
PDE stopped for TPA shutdown
Tip
You don’t have to wait for the database to shut off before continuing.
Shut down the virtual machine
poweroff