Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: How do you specify "location" in the BPA Teradata connect dialog
Topic Summary: How do you specify "location" in the BPA Teradata connect dialog
Created On: 07/10/2015 08:04 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 07/10/2015 08:04 AM
User is offline View Users Profile Print this message

Author Icon
TonGordon
Journeyman (50-99)

Posts: 87
Joined: 05/17/2011

Hi,
Tyring to connect our bpa to Teradata. Specify the Teradata OLEDB driver from the list of drivers and that seems to work. In the jpg attachment dialog there is a picture of what the Teradata connect dialog looks like. There is a box called "location" that seems promising. I assume that would be the location of the Teradata driver on the agent machine that bpa is running on (if that's not what your supposed to put there, please tell me). But on my installation the "location" box is greyed out. How do I get it to let me put something in "location"?

With Oracle and MS Sql you have a driver, you specify a pingable (in dns) server, and you can connect. Teradata is different. Teradata seems to know some Teradata directory server in the driver and then you connect.

 Category Survey
AutoMate BPA Server 9 version:
Windows version:


Click for full image
Click for larger image

 07/13/2015 05:18 PM
User is offline View Users Profile Print this message

Author Icon
Valentineo McGowan
HelpSystems

Posts: 766
Joined: 09/03/2013

Hello TonGordon,

Where precisely is the BPA Server database located?
Does it reside within an Oracle or SQL or MySQL DB?

The BPA datastore must reside on one of the above 3, not excluding SQL Server Express.

BPA Server connects to the following:
Database Datastore:
Oracle 10g+
MySQL 5.0+
SQL Server 2005+
SQL Server Express 2008 R2+ (included in BPA Server)

I believe you were attempting to get this question answered on a previous forum thread. I thought you were seeking assistance building a step within a task wherein a connection to a TeraData DB would be supported; that is quite different where we allow our data to be stored for BPA.

I hope this clears things up.

 Category Survey


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

Valentineo McGowan | Technical Consultant
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665
 07/14/2015 06:27 AM
User is offline View Users Profile Print this message

Author Icon
TonGordon
Journeyman (50-99)

Posts: 87
Joined: 05/17/2011

Sorry, my wording wasn't clear. This is just a vanilla question. I just want to read a Teradata database with BPA. Yesterday we found that "All" option for SQL Query pretty flexible and you can set any of those parameters. But I'm still not connecting to Teradata and I haven't even gotten to the point where I would do an LDAP connection. I would think that the Teradata client would have to reside on the Agent machine that the Workflow runs on. Is that true? If the Teradata client is on the Agent machine, how do you tell BPA where the client is?

 Category Survey
AutoMate BPA Server 9 version:
Windows version:
 07/14/2015 02:33 PM
User is offline View Users Profile Print this message

Author Icon
Alex Escalante
HelpSystems

Posts: 871
Joined: 02/26/2014

Hello Ton,

Yes the client would have to reside on the Agent machine as that is where the actual task will be running when live. However, when initially building the step, you will need to have the client visible (on the same machine that you are building your task with) so that you can create the connection.

Please let us know if you have any questions or concerns.

 Category Survey


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

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1751 guests browsing this forum, which makes a total of 1751 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog