ADO DB Connectors Preview

NoelR

I had the opportunity to test a preview of the new database connectors developed by the Anaplan Data Orchestrator (ADO) Team, and I wanted to share my experience with you.

To set up the testing environment, I used my AWS account and the RDS service to launch four types of databases: PostgreSQL, MySQL, Microsoft SQL Server, and Oracle DB. The first three are available within AWS’s Free Tier, which made it easier to keep costs low during the tests.

I was particularly mindful of the configuration options for each database to minimize expenses. Whenever possible, I selected the Free Tier templates and opted for "micro" server instances, ensuring the setup was both cost-effective and efficient for my testing needs (MSSQL Server needed a "small" instance to get reasonable response times and Oracle minimum is "large").

For PostgreSQL on AWS RDS, be aware of this: https://stackoverflow.com/questions/76899023/rds-while-connection-error-no-pg-hba-conf-entry-for-host

All my databases were running on AWS, let's now use the DBeaver Universal Database Tool community edition to check connections and populate the DBs with some data.

When installing DBeaver I've selected the option to also install the SQLite sample Database and used the Employee table description and data to export/import data into my AWS databases.

Last step, let's create ADO Connections and extract the Employee datasource for each databases.

Start by creating a connection selecting the database and filling the correct parameters.

And then create a Source Data for each Connection to extract the Employee table.

Here are all the Source Data defined and working well.

Anaplan Data Orchestrator (ADO) is a powerful tool simplifying data access to #PlanWithAnaplan. Feel free to visit the Anaplan Data Orchestrator documentation.

Be trained in Academy with the ADO Certification.

NoelR

Probably worth it to mention the Anaplan Data Orchestrator IP and URL allowlist from the documentation (similar to the list for CloudWorks).