To connection between unix machine with teradata environment is needed to install ODBC Driver and some others components (dependencies). All Items can be found in Teradata Downloads site: https://downloads.teradata.com/
Teradata OBDC Driver has 3 dependecies:
1. Shared common components for Internationalization (TDICU)
2. Teradata GSS client package (TeraGSS)
3. Teradata Tools and Utilities Base (TTU)
After download all items, run as root: rpm -ivh “component_name” –nodeps
Eg: rpm -ivh teragss1510-15.10.02.06-1.noarch.rpm --nodeps
Use “–nodeps” only to not need to install in order
This steps should still be performed in SQLserver Host:
The pump process configuration is very simple, its only function is to transport the trail files to destination.
ADD extract P_MSQL, exttrailsource ./dirdat/tr
C:\goldengate> edit param P_MSQL
SOURCEDB db0sql1, USERID ggate, PASSWORD ??????
CACHEMGR CACHESIZE 2GB
rmthost teradata1.net, mgrport 8809
Still in the SQLserver Host, is need to create a definition file, wich will be used in gg-teradata.
First, create a “tables.def” file that should contain a dblogin and tables that will be replicated.
defsfile tables_sqlserver.sql purge
USERID ggate, PASSWORD ??????