Yellowfin makes business intelligence easy for anyone, from small business to massive enterprises. Here’s how to configure it with DataDirect JDBC connectors.
This tutorial comes out of our recent tutorial rumble, courtesy of John Sullivan, Senior Technical Support Engineer, DataDirect Support Team. We hope to keep bringing you the best lessons and tutorials available to help you achieve all of your data connectivity goals.
Start Server - <Yellowfin Home>\appserver\bin\startup.bat
Stop Server - <Yellowfin Home>\appserver\bin\shutdown.bat
Connect to Yellowfin server - http://<Computer Name>:<Port Number>
•<ComputerName> is the name of the machine on which Yellowfin was installed
•<Port Number> is the port chosen during installation (port 8080 by default).
Once you are at the home page, you can login with the user credentials below:
•User name: firstname.lastname@example.org
This example shows how to configure a connect for JDBC MongoDB driver. Other DataDirect JDBC drivers will follow a similar format.
How to add additional Progress DataDirect drivers:
com.pb.spectrum.jdbc.driver.BIDataStoreDriver, ß Be sure to add comma at end of previous line
com.ddtek.jdbc.mongodb.MongoDBDriver ß Driver class added for Mongo DB driver
Source Name: MongoDB (Any name is good)
Database: Generic JDBC data source
JDBC driver: com.ddtek.jdbc.mongodb.MongoDBDriver
Connection String: jdbc:datadirect:mongodb://<MyServer>:27017; SchemaDefinition= C:\\<PathToMappingFiles>\\MyServer.config;
User Name: xxxxxx
Note: In this example, the user name and password were not required for a connection to MongoDB.
A successful connection will display the database name and metadata information.
At this point, Yellowfin reports can be built using the new data source.
To edit a current data source, select "Data Sources" and then click on the data source to edit.
MongoDB connectivity via JDBC or ODBC is easier than ever with DataDirect JDBC and ODBC connectors for MongoDB. They provide fast SQL access to business critical data while also enabling you to access NoSQL data without additional server installations. Integrate your MongoDB data without having to duplicate data or flatten complex documents. Visit our information page to learn more or try it free for 15 days.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.