Is it possible to access Amazon Redshift data warehouse via ADO?
Hello, Brain Trust!
My organization uses Amazon Redshift data warehouse and some data we need for Anaplan will be stored there in the near future. The current assumption is that we will use Informatica to query, stage, and then import to Anaplan, BUT…. I really was hoping we could use ADO. In a prior life, I used Anaplan Connect to directly query a local data warehouse and load to Anaplan, which was very convenient.
I see there are options for Amazon S3 (which is just file storage) and there are options for various flavors of SQL/SQL Server. But looking at the SQL connector setup, it appears to access SQL-based relational databases housed on local/on-prem servers and not cloud servers like Redshift.
Does anyone have experience with this? I'd love to pick your brain.
Thanks in advance!
Stacey