Tibco cloud - where to specify test on agent when setting up new sql server (on prem) connection

[Benjamin Church]

Hi - I'm new to Tibco and just using the trial edition to see whether it will suit. My aim is to ETL Dynamics 365 data to our on prem sql server. So I have done the following:

1) setup d365 connection (no problem)

2) installed the on-prem agent on our SQL server

3) checked it is running ok and Tibco agents list is as online

4) installed the MS SQL connector

Now when I try to setup the sql connection via connections/create and choose the sql server type I get the usual options for name / port / user / password etc. but no option to test on the agent I just setup. So it won't successfully see the sql server and therefore I can't save the connection.

I think I am missing something fairly obviousl, but if anyone knows what I am doing wrong I would greatly appreciate it!

Thanks, Ben

[Nick Roelandt]

Hi Ben,

 

Do you want to try to zoom out in your browser and /or clear your cache to see if that makes a difference

 

thanks

Nick

[Hursh Kher]

Hi Ben,

There are two kinds of SQL Server connectors:

1) Microsoft SQL Server (Connect)

2) SQLServer Connector (Develop)

The first one is for Scribe and the second one is for Flogo apps.

Which one were you trying to use based on the above capabilities (Connect or Develop)