Build, protect and deploy apps across any platform and mobile device
Leverage a complete UI toolbox for web, mobile and desktop development
Automate UI, load and performance testing for web, desktop and mobile
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Build mobile apps for iOS, Android and Windows Phone
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premise data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
Automate decision processes with a no-code business rules engine
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: email@example.com
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.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2017, Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, 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 or appropriate markings.