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.
Cloudant Destination Connection
Even easier, enter your database name, username and password.
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.
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.
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.
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.
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.
If you have any questions on this or other features of Conductor, feelf free to drop us an email at firstname.lastname@example.org