When you use query with SQL option to acquire data set, you can see few of the connections in red and green. What is the meaning?

To use SQL query to create dataset, go to file → New

Click on Query with SQL option to download a dataset and click on Next. JDBC drivers has to be installed for database middleware for using SQL query. The access driver is .jar files you can download from vendor site and copy to driver folder in application path.