Cloudant is an amazing database-as-a-service platform. With features such as geospatial and search support, Cloudant can provide developers with powerful features out of the box and is scalable to hold as much data as you can throw at it.

The question still remains: how can you move data into Cloudant without bespoke coding? With Conductor, this is a simple 4 step process so developers can move SQL Server or Oracle databases into Cloudant within minutes.

1. Create your data stores

To create the data stores, simply click on Data Store and create a source and destination data store. In this case we have a SQL Server data source and Cloudant destination.

ODBC Data Source Connection

Simply select the agent that can connect to your database, select the database type, and paste in a connection string.ODBC Source Connection

Cloudant Destination Connection

Even easier, enter your database name, username and password.

Cloudant Destination Connection

2. Create a process

Next, click on Processes and build the process to move the tabular data from your database to Cloudant.

Select the source and destination data stores

Conductor can move data between different platforms and locations by simply selecting the source and destination stores.

Cloudant Load Step 1

Select what you want to move

You can move as many tables as needed in one step (no need to build a load for each table) or you can enter a SQL query to select and transform data from the source.

Cloudant Load Step 2

Set the threshold for the load

Since Conductor can automatically fix data errors during a load, you can set the tolerances for the load. Source data coming in from dodgy spreadsheets? Drop the threshold to Low and Conductor keeps things clean were possible. If you want the load to stop if anything seems iffy, remove the checkmarks and set the column matching threshold to High.

Cloudant Load Step 3

And you are done!

From here you can execute the process or schedule it to run later. If you run it now, your data will start flowing into Cloudant within seconds.

Cloudant Load Step 4

3. A populated Cloudant database

After logging into Cloudant I can see that the database has been fully populated. Now I can get onto the fun stuff without having to manually shift data around.

Cloudant Load Step 5

If you have any questions on this or other features of Conductor, feelf free to drop us an email at heya@eight-wire.com