Oracle Data Visualization Desktop (DVD) Configuration with Teradata

Applications
Applications covers the world of Teradata apps, including apps offered by Teradata (such as TRM or DCM), as well as best practices and methodologies for building your own Teradata-connected apps.
Teradata Employee

Oracle Data Visualization Desktop (DVD) Configuration with Teradata

Oracle Data Visualization gives you the best of both worlds: accurate, consistent analytics you can rely on and the ease-of-use and speed you need to change it.  Rich, interactive visuals show the story in your data and make it easy for you to share insights.  As easy as you expect—upload your data, then drag and drop your way to compelling analysis. 

This article shows how to install Data Visualization Desktop (DVDesktop), set up connectivity to Teradata and has examples of using them together.

Installing DVDesktop:

  1. Download the DVDesktop installer from the below link:

http://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visuali...

1.png

2. Once you are done with the download (exe file), run the installer, provide installation directory and then click next.

2.png

3. Keep the default check box and then click next and click on install button.

3.png

4. Once the installation is completed, click next and then click Finish button.

4.png

5. Once you click on Finish button, it launches DVDesktop.

5.png

 

Installing Teradata TTU's :

 6. Download latest Teradata TTU’s from this site:

           http://downloads.teradata.com/download/connectivity

 7. Unzip the file and navigate to Disk1 folder

 8. Inside Disk1, execute TTU.exe file 

6.png

9. Now, you should be able to see Teradata Welcome screen, select Install Product

7.png

10. It takes you to Teradata Tools and Utilities Install wizard, select only ODBC drivers and then click install. 

8.png

11. Once you are done with the installation, click on Exit.

 

Integrating DVDesktop with Teradata:

12. Open C:\Users\mchittip.ORADEV\AppData\Local\DVDesktop\extdriver.paths file.

13. Update the file with TD installed location,

               "C:\\Program Files\\Teradata\\Client\\15.10\\bin"

14. Now, save, close and re-open the DVDesktop to effect the changes done.

15. Add a New Connection in the DVDesktop with Teradata data source. 

9.png

16. Provide TD connection details and click Save button.   

10.png

17. Now, you should be able to save the connection without any errors and should be able to see the connection listed on Data sources page as below:   

11.png

18. Now add your data sources to project.

19.To add, select the database and then select required tables to add to the project.    

12.png

20. Once you select the required table and then click ok, you should be able to see the data without any errors.    

13..png

21. Now, click on Add Data Source and you should be able to see the newly created data source on the Data Sources page as below:

14..png

22. Now, navigate to main page and click on create project.    

15..png

23. Select the Data Source and then click on Add to Project button.

16..png

24. Once you are done with adding the data source to the project, you will see the products table on the project tab.     

17..png

25. Finally, you can visualize your data in multiple visualizations as shown below:     

18..png

          

19..png

            

 

Note:- The following Teradata TTU's are supported as of now.

--------------------------------------------------------------------------------------------------------------------

Version                 Display Name
--------------------------------------------------------------------------------------------------------------------
15.10.00.00           Shared ICU Libraries for Teradata 15.10
15.10.00.00           Shared ICU Libraries for Teradata nt-x8664 15.10
15.10.00.00           Teradata Data Connector 15.10
15.10.00.00           Teradata Data Connector nt-x8664 15.10
15.10.00.01           ODBC Driver for Teradata 15.10.0.1
15.10.00.01           ODBC Driver for Teradata nt-x8664 15.10.0.1
15.10.00.01           Teradata CLIv2 15.10.0.1
15.10.00.01           Teradata CLIv2 nt-x8664 15.10.0.1
15.10.00.05           Teradata GSS Client nt-i386  15.10.0.5
15.10.00.05           Teradata GSS Client nt-x8664  15.10.0.5
15.10.03.00           Teradata Tools and Utilities - Base 15.10.03
--------------------------------------------------------------------------------------------------------------------

 

Version                 Display Name
--------------------------------------------------------------------------------------------------------------------
15.10.01.00           Teradata GSS Client nt-i386  15.10.1
15.10.01.00           Teradata GSS Client nt-x8664  15.10.1
15.10.01.01           ODBC Driver for Teradata 15.10.1.1
15.10.01.01           ODBC Driver for Teradata nt-x8664 15.10.1.1
15.10.01.01           Shared ICU Libraries for Teradata 15.10.1.1
15.10.01.01           Shared ICU Libraries for Teradata nt-x8664 15.10.1.1
15.10.01.01           Teradata CLIv2 15.10.1.1
15.10.01.01           Teradata CLIv2 nt-x8664 15.10.1.1
15.10.01.01           Teradata Data Connector 15.10.1.1
15.10.01.01           Teradata Data Connector nt-x8664 15.10.1.1
15.10.05.00           Teradata Tools and Utilities - Base 15.10.05

 

 

1 REPLY

Re: Oracle Data Visualization Desktop (DVD) Configuration with Teradata

hi Sir ,

 

i have an issue and i need you help

 

i have just installed Teradata version 16 on my linux 7 server and i try to configure it with OBIEE 12.2.1.2.0 but now my obis1 server component is down

and the error is

 The start operation can not be performed on the Dummy BI Servers component.

 

can you please tell me how to fix this problem

 

 

thanks