Showing posts with label Software. Show all posts
Showing posts with label Software. Show all posts

Tuesday, 25 December 2018

MongoDB Atlas - Off Premise Way (DBaaS)

MongoDb also provide cloud services (Database as a Service - DaaS), called MongoDB Atlas, to host your mongo database on cloud. Let's see how we can setup an cloud account and access the MDB from local machine.

Cluster Step :
1. Create an account on
2. Once you are in, the very first thing which it asked to choose your cluster configuration.
2a. It gives you to choose one of cloud service which are - AWS, Google, Azure, Choose whatever you like
2b. But always choose "FREE TIER CLUSTER" (M0 Instance) else there will be usage charge.
3. Once you have selected appropriate config, it will start building your mongoDB Cluster, it will take few mins to complete the setup.
4. When done, it will be like this, usually use Cluster0 as name, you can modify it though -

How to access from local system :

You need to install Mongo Shell to access cloud db which comes with Mongo DB pkg. You can download and install on your OS (Windows/Linux) from here -

1. Login on and click on Clusters in left hand side list.
2. Click on Connect and follow below steps -
3a. Whitelist your id so that you can connect with your system or any ip address. Click on "Add a different IP Address" and to allow to connect from any system, Use as IP address
3b. Create your cluster credential

4. Once done, you will see the below screen
5a. Now, Click on Choose connection method and click on "Connect with Mongo Shell" -

5b. Now, click on standard connection string

6. Copy the string and replace the <PASSWORD> with the password which you created in Cluster Setup Step #4.
7. Now, As I have installed the MongoDB Shell in Step #1, we need to add MongoDB Bin directory path into system path. You can add this path into windows env variable or Linux user profile so that you can access mongo command from any location.
8. Once path has been added, open cmd or terminal and paste the connection string which you copied and modified in step #5

9. When connected successfully, you can try to run commands as below -

10. For more commands, you can visit this link -

11. Mongo Atlas Cloud Step has been completed and verified successfully. You can connect with the same connection string from any system (if firewall allows and have mongo shell installed)

Let me know in comments if you face any issue while doing Atlas setup.
Next Post on this Series and more on MongoDB can be find here -> LINK

Like the below page to get the update  
Facebook Page      Facebook Group      Twitter Feed      Google+ Feed      Telegram Group     

Thursday, 6 October 2016

Difference between IBM CDC and CDD

Now a days I am busy with an another IBM tool called CDC - Change Data Capture, now knows as IBM Infosphere Data Replication.
IBM CDC replicates your heterogeneous data in near real time to support data migrations, application consolidation, data synchronization, dynamic warehousing, master data management (MDM), business analytics and data quality processes.
In layman's terms, you can replicate any data automatically in near real time.

When we were at initial stage of our POC, we got a doubt between IBM CDC and CDD (Change Data Delivery) which one we have to use and what is the difference and all. Whenever we were googling about IBM CDD, getting the result with IBM CDC links, In some way we were sure that both are same tool or related with each other. Luckily we found an IBM link which says -
InfoSphere CDD is the exact same code (product) as InfoSphere CDC. The only difference is the licensing model. Please reach out to your IBM Sales Representative for additional details 

So we have contacted our IBM sales buddy to understand the licensing model and this is what we got to know -

* IBM CDC and CDD is same product
* IBM CDC comes with Source and Target Agents and there is individual licensing cost for each one agent.
i.e. - Assuming you are having 2 different database vender (Oracle, Db2) at source side and 3 target db vender (SQL Server, MySQL, Netezza) so you have to pay for 5 replication CDC agent which can be increase or decrease with no of different database software you are using.

* IBM CDD (Change Data Delivery) comes with little relief with costing but only if you already have IBM DataStage license. IBM CDD comes with multiple source agents software and one target agents for IBM DataStage which saves the cost.
 i.e . - Let's take the previous example, We need to buy 2 (for source dbs) + 1(for datastage) license to use Replication.
The benfit here is, you only need to pay for 1 target agent (for DataStage) and use DataStage to deliver your data to any target which saves multiple target license cost.

This is the only reason why they have different names despite being the same software - 
IBM CDC - Change Data Capture ( n source + n target )  [DataStage not required]
IBM CDD - Change Data Delivery ( n source  + 1 target ) [DataStage required]

Like the below page to get update