10-12-2018 04:31 PM - edited 07-09-2021 04:40 PM
Alteryx Connect has a few architectural components, first of which is the Alteryx Connect Server. This is a stand-alone server, either on your premises or your managed private cloud. The technical specifications and hardware requirements for this server are available here, and can scale vertically with additional CPU cores. There are three main application components to the Connect Server:
The second server related to Alteryx Connect is the Alteryx Server. Alteryx Server exposes Alteryx workflows via a website called the Gallery. These workflows may reference a variety of data sources.
Alteryx Connect is a centralized view into the world of data within your enterprise, unlocking tribal knowledge, and allowing data workers to become more efficient and effective!
Recently I upgraded Alteryx to 2019.1 and I am using Oracle 64-bit for my DB connections. Since going to 2019.1, I am required to run my local connections to my Oracle DB using the alias connection process, that merely translates the connection to Oracle OCI, while moving to the Alteryx Server platform requires it to be defined as the Oracle OCI connection … without the Alias.
This means that I have to basically have two versions of my workflow with one for my local connections and another for the Server connections. This is very cumbersome as to which workflow to run and if you forget one connection change the WF blows up and you fix it and have to start over.
Are there some options that need to be set to allow the same connection on either platform? Before 2019.1 I did not have this issue at all.
Thanks,
Joe Sciarrino
My friends. Considering the text above, this hyperlink is broken: "The full list can be found here"
I would like to know the complete list of sources.
Thank you.
Rafael Andrade
This is the full list of sources https://help.alteryx.com/20193/connect/load-metadata . It has the list of all metadata loaders. Please keep in mind that anything with an ODBC driver can be connected to, it will just require some configuration on your side and wont be aviailable out of the box.
@MattD ,
Have you ever had a case where the different services for Connect have been deployed to separate resources?
I was thinking about this the other day, but assumed because of how light the application is (other than storage) it doesn't justify the use of multiple servers given the processing is already done on the Alteryx Server.
Is there any plans to connect to data sources using lua scripts for the purpose of connecting to JDBC sources of data?