ColdFusion11 helps you build and deploy web and mobile apps. Learn how easily it integrates with DataDirect JDBC drivers to expand connectivity to cloud sources like Salesforce and Oracle Service Cloud.
ColdFusion11 is an application server for building and deploying web and mobile applications. ColdFusion integrates with Progress DataDirect JDBC drivers seamlessly and already supports the latest version of DataDirect drivers for a number of relational databases. The full list is MySQL, Oracle, DB2, Informix, and SQL Server (as you can see on page 115 of their documentation).
If you are looking to expand this connectivity to a cloud source such as Salesforce and Oracle Service Cloud, or even to big data sources such as MongoDB—this tutorial will show you the easy step-by-step guide for expanding your ColdFusion connectivity.
I've put together a JDBC for Windows installation video that you can watch right here:
Locate the DataDirect JDBC .jar file for the driver that you want to integrate with your Adobe ColdFusion environment by looking in the <DataDirect Installation Directory>\lib\ folder. The default location will look similar to: C:\Program Files\Progress\DataDirect\Connect_for_JDBC_51\lib. Below I have an example of copying the MongoDB and Salesforce driver’s .jar files.
In order for the driver .jar file to be picked up by the application server, you must navigate to the Enterprise Manager > Instance Manager and restart the server.
Enter a Data Source Name and select Other for the Driver. You will then define your data source by entering the JDBC URL, Driver Class, User Name, and Password. I have given an example of the MongoDB and Salesforce driver definitions below. For a driver other than these, please refer to the DataDirect Connect for JDBC documentation for the Driver Class and URL syntax.
After clicking on Submit and saving your data source successfully, you can click on the check mark to verify the JDBC data source connection. It will appear with an OK to show you that you have successfully made your connection!
If you are seeing an error similar to what is below. Please double check that you have listed the correct Driver Class Name. In this example, the driver class should be com.ddtek.jdbc.sforce.SForceDriver .
DataDirect Connect for JDBC drivers offer proven performance, increasing your throughput and CPU efficiency along and memory footprint delivers faster response times and more scalable applications. If you want strong security, quality, and comprehensive coverage then pick up your free trial today!
Idaliz is a Sales Engineer with Progress. After receiving her undergraduate degree from Duke University in Civil and Environmental Engineering, Idaliz Baez spent a year at NASA Goddard Space Flight Center gaining on-the-job experience before returning to Duke in pursuit of her Masters of Engineering Management degree.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.