Here at BI Connector, we continuously aim to give you the best experience when visualizing all kinds of data. Therefore, we are happy to announce that the latest version of BI Connector now allows users to visualize Taleo data.
Connect Taleo with Tableau, Power BI, or Qlik.
Companies rely on HR analysts to collect and study data related to jobs, costs, and issues that affect the company. Therefore it is crucial that HR analysts are able to access information that is accurate in a timely manner. Unfortunately, when using Taleo, HR analysts are stuck with the cumbersome task of manually exporting data from Taleo before also manually importing the same data to a modern visualization tool such as Tableau, Power BI, and Qlik. This is not only time consuming, but it can also be quite costly. In addition, IT department will require Taleo Connect Client (TCC) expertise, which is hard to find, to automate the exporting of Taleo data. These are just a few tasks that make Taleo a difficult tool to use.
BI Connector is now giving companies the ability to visualize Taleo data/OBIEE data subject area and reports directly in their chosen modern visualization tools such as Tableau, Power BI, & Qlik. Now HR Analysts and IT teams supporting them, can spend less time on data wrangling and focus more on analyzing recruitment data so that the organization can recruit and onboard the right talent for the right jobs faster.
See how you can easily configure Taleo ODBC DSN using BI Connector in this video:
Taleo DSN Configuration for Reports & Subject Areas | BI Connector - YouTube
Get the latest version of BI Connector and visualize Taleo data now!
Over at BI Connector, our goal is to give you the best experience when visualizing OBIEE data. Therefore, we are pleased to announce that BI Connector v4.1 is released!
Connect Power BI Cloud to OBIEE using On-Premise Gateway
BI Connector now allows you to connect from Power BI Cloud to OBIEE using Power BI on-premise gateway. Power BI is a cloud service that sits in the Microsoft data center and by default does not have the ability to connect to OBIEE data in your environment. In order to do so, you need the Power BI Gateway and BI Connector Server Edition. As a result, you may now get data from your on-premise OBIEE or Oracle Analytics Cloud onto your Power BI for creating reports and dashboards.
By being able to connect Power BI Cloud to OBIEE, you can now generate intuitive Power BI visualizations in minutes using OBIEE data with the help of BI Connector. In addition, Power BI Gateway supports a multi-developer environment allowing BI admins to create gateways so other BI developers can use that specific gateway for their reports or dashboard. On-premise gateway also supports a number of connections; import data, schedule refresh, DirectQuery, and Live Connection.
To download the latest version of BI Connector for Power BI, click here now and start visualizing!
BI Connector has opened a plethora of options for companies to visualize OBIEE subject areas and reports in modern visualization tools like Tableau, Power BI, or Qlik. Many leading organizations around the world have evaluated and purchased BI Connector desktop and server edition to simplify access to OBIEE data warehouse.
As a BI Manager or Architect tasked to evaluate BI Connector for your company, you may be wondering how would you get started? This white paper aims to help you evaluate BI Connector as a possible solution and see if it meets your business requirements.
There are three steps
Understand your users
Form a core team for evaluation
Understand initial use cases
By following the template and workflow provided in the white paper to evaluate BI Connector, you will be able to efficiently get the right individuals working together on the correct use cases. Your users will then be able to experience the power and value of BI Connector in unlocking data visualization and blending abilities of these modern visualization tools.
View the white paper and learn to get the right visualization/data to the right people:
If your team has any questions on how to use BI Connector, login to <BI Connector Support> to access knowledge base articles, white papers, how-to videos, and to request help by creating a support ticket.
Looking to connect Power BI to OBIEE and using it as your primary visualization tool?
If your organization uses OBIEE 11g or 12c as the enterprise data warehouse and reporting platform, it is almost certain that you’d be spending hours and days every month moving data from OBIEE into your favorite tool.
An average user spends several hours per week and 4 to 5 work days per month in export/import/ETL of OBIEE data into Power BI. In addition, it could cost several hundreds of thousands of dollars to recreate all the OBIEE reports in Power BI.
In order to stay competitive in the age of agile analytics and artificial intelligence, it’s critical to access and visualize all your data, whether they are in the cloud, excel, SQL database or OBIEE, in a single modern visualization tool such as Power BI.
Join us in the upcoming webinar on Tuesday, January 29th, 2019 @10AM PST to learn how BI Connector, which installs in minutes, can help you spend less time in export/import of OBIEE data and gain more time to analyze OBIEE data in Power BI.
The essential steps to get started with connecting Power BI to OBIEE
How to save time and fast track visualization by connecting Power BI to existing OBIEE reports
Pros and cons of using Power BI direct query vs. import
How to use filters to optimize data volume and query performance
How to use BI Connector query settings to optimize OBIEE queries
How to automate publish of OBIEE data to Power BI cloud with BI Connector Server Edition
Live demos of visualizing OBIEE Reports and Subject Areas with Power BI
All attendees will receive a free 30-day free trial extension key for the BI Connector.
In this webinar, we discuss how you can “Save Time, Reduce Errors, and Create Visually Appealing Reports from OBIEE Subject Areas and Reports.” There is currently an important trend that is taking place amongst many organizations who are using OBIEE as their BI reporting tool. We’re gradually seeing more businesses adopting Tableau, Power BI, and Qlik as their visual analytics tool. They find them easy to learn, user-friendly and have a shorter time to analytics.
However, many problems have risen. Users are realizing a large amount of time is wasted when it comes to visualizing legacy BI data. Since the most important business data is still in OBIEE, users are forced to dedicate 4-5 hours per week to manually exporting, importing, and wrangling the OBIEE data into their new preferred visualization tool. You are potentially looking at a $10,000 productivity loss for every user per year.
On the flip side, IT teams have already invested millions into OBIEE. They are also frustrated because users no longer are interested in OBIEE UI. If IT teams choose to duplicate the OBIEE semantic model, business logic, and aggregations in Tableau, Power BI, or Qlik, this could easily cost $250,000 for each subject area. As you can imagine, this is not an easy scenario.
In this webinar, we discuss how you can eliminate the productivity loss of $10,000/user and also avoid the duplication cost of $250,000 per subject area by using BI Connector.
Increased efficiency – productivity savings of $10,000 per user per year
What is your favorite visual analytics tool: Tableau? Power BI? Qlik? Anything else?
Tableau, Power BI, and Qlik are great choices, but if your organization uses OBIEE 11g or 12c as the enterprise data warehouse and reporting platform, it is almost certain that you’d be spending hours and days every month moving data from OBIEE into your favorite tool.
An average user spends several hours per week and 4 to 5 work days per month in export/import/ETL of OBIEE data into Tableau, Power BI, and Qlik. In addition, IT teams spend several hours every day worrying about the data governance and shrinking usage of OBIEE.
You will see a live demo of connecting from Tableau, Power BI, and Qlik to OBIEE in minutes using BI Connector. Be ready with your questions and we’ll be more than happy to discuss them in the webinar Q&A session.
As an added bonus, stay with us until the end of the webinar to receive a special 90 days free trial license key for BI Connector.
We look forward to seeing you there for our live demo of Tableau, Power BI and Qlik to OBIEE BI Connector!
Over at BI Connector, we continue to work towards improving our products in order to give you the best experience when it comes to visualizing OBIEE data. That is why we are happy to inform you that BI Connector v3.8 has just been released.
BI Connector v3.8 offers two new features: an easier connection from Power BI to OBIEE using DirectQuery and visualizing OBIEE subject areas with Qlik Sense. Let’s dive into the details of the new features in BI Connector.
Connect from Power BI to OBIEE using DSN and DirectQuery
BI Connector in DirectQuery mode allows Power BI users to query live real-time data from OBIEE. Similar to Tableau’s live data connection, DirectQuery mode is a query-then-import model whereas ODBC mode is an import-then-query model.
BI Connector in DirectQuery mode allows Power BI users to query live real-time data from OBIEE. Similar to Tableau’s live data connection, DirectQuery mode is a query-then-import model whereas ODBC mode is an import-then-query model. Learn more about DirectQuery and how it compares to ODBC approach in this article.
In the previous version of BI Connector, users had to manually enter the OBIEE connection information every time for DirectQuery connection. This method was very cumbersome and time-consuming. However, the new BI Connector v3.8 has solved this problem by allowing users to connect to OBIEE using the pre-configured DSN name. Connecting to OBIEE via DirectQuery is now easy and can be done in 3 simple steps:
Connect from Power BI to OBIEE using the DSN. View the video bellow:
Connect from Power BI to OBIEE using the DSN - YouTube
QlikSense to OBIEE Subject Area Connector
In BI Connector v3.7, we launched the QlikSense to OBIEE Reports Connector. Shortly after, organizations such as Stratasys, the world leader in 3-D printing, are using this tool to integrate QlikSense to OBIEE.
We then noticed a limitation with BI Connector v3.7 was that users couldn’t create QlikSense visualizations from OBIEE subject areas. In order to visualize OBIEE data in QlikSense, users had to create a separate OBIEE report and then connect to it using BI Connector. Report creation was an inconvenient extra step that users had to go through.
BI Connector v3.8 solves this problem. We are excited to announce that we now provide a direct connection from QlikSense to OBIEE subject areas. With this new capability, users can now use the powerful in-memory visualization capability of Qlik Sense to visualize OBIEE data from subject areas and reports.
Learn more about this new feature in this article by my colleague Ridwan here.
You can review the BI Connector v3.8 release notes here.
Qlik Sense is a great high-performance tool that is able to visualize data since it uses “in-memory” data indexing technology. In this blog, we will explore ways on how we can visualize data by connecting Qlik Sense to OBIEE Subject Areas using BI Connector.
Creating Subject Area DSN
Create a DSN with BI Connector in the ODBC Data Source Administrator(64-bit) and choose the “Subject Areas” option as the Data Source Type.
Watch this video on how to create DSNs using BI Connector:
BI Connector | How to Configure Your OBIEE DSN - YouTube
Connecting Qlik Sense to OBIEE Subject Areas
Start by connecting to the Qlik server in your browser. You can either create a new app or open an existing app. Proceed to select the “Script Editor” option to load the subject area data from OBIEE using BI Connector.
Click on “Create New Connection” to add the BI Connector DSN and select the “ODBC” option from the DSN.
You will then be presented with the list of DSN you have created. Click the “BI Connector DSN”, enter your credentials before clicking “Create”. You will now see the BI Connector DSN listed in the data connections panel.
Click on the “Select Data” icon under the BI Connector DSN to select the table and insert the script. You will also have the option of directly inserting the script.
The “Database” field with your OBIEE Server Name automatically filled by BI Connector.
The “Owner” field will show a list of subject areas from OBIEE. Select a subject area.
The Tables in Subject Area will be listed under the “Tables” column.
Apply filters to the tables if needed.
Select the required column.
The script will then be automatically generated.
Click on “Insert Script”.
For joining tables in the same subject area, use GZID as the join column. GZID is a BI Connector created virtual column that can be used to create dummy joins in Qlik Sense. Since the actual join conditions are defined in OBIEE, using GZID as the join field enables BI Connector to push the query into OBIEE and execute the joins in OBIEE. You can also perform join by inserting a script similar to this.
FROM "Northwind-Test"."Customers" AS "CustomerTable"
INNER JOIN "Northwind-Test"."Orders" AS "OrdersTable"
ON "CustomerTable"."GZID" = "OrdersTable"."GZID";
Click on the “Load Data” icon to load the result of the query into your Qlik Servers in-memory space. Now go to “App Overview” and start creating visualizations of your choice.
Try Qlik to OBIEE Subject Area BI Connector for Free!
BI Connector offers you the easiest and most effective way to integrate Qlik Sense to OBIEE Subject Areas. Download BI Connector herefor our 30 days free trial and tell us about your experience by emailing us at email@example.com. We look forward to hearing from you!
When three Fortune-500 companies joined together to create a single $19 billion enterprise data storage solutions provider, it was up to the mergers and acquisitions team to deal with the most challenging component of the transition. They needed to devise a plan for integrating the three thousand applications and IT systems from its three multi-billion dollar organizations. Dealing with a large amount of extremely sensitive information is not only extremely risky, but also laborious and stressful. When creating an integration plan, it is important to consider important questions about ERP/CRM/HR/BI and other systems:
Which systems from the acquired company are retained?
Which systems are migrated over to the parent company’s systems?
What is the integration strategy for connecting retained systems to the parent company’s IT systems?
What is the data migration strategy for the replaced systems?
Once a plan has been laid out, the team can then start the integration process which can take months to years depending on the complexity of the acquired company. During this time, there will be a constant flow of data from the acquired company to the parent company. The parent company may require the reports to be in a specific format. Analysts must manually extract and transform the reports themselves to ensure consistency. Given the insatiable demand for data during integration, the M&A project teams must look into solutions that will help reduce laborious tasks and maintain the team’s focus on the core M&A project. Automating the data extraction, data transformation, and creation of reports from the acquired company’s BI platform is a low hanging fruit that can reduce a significant amount of manual labor and help the team focus on critical M&A tasks.
Find out more about minimizing M&A risk through automation when OBIEE is the BI platform in either the parent or acquired companies.
BI Connector v3.7 is now available. It is packed with powerful new capabilities, usability enhancements, and of course, bug fixes.
QlikSense to OBIEE BI Connector
Manage Reports List
Usability improvements for Tableau Extracts
Introducing QlikSense to OBIEE BI Connector
We are excited to announce the newest member of the BI Connector family. The Qlik to OBIEE BI Connector is designed to help customers modernize their OBIEE environments using QlikSense as the visualization tool. Within a few minutes, users can seamlessly connect from QlikSense server to OBIEE Analysis (Reports) catalog using their OBIEE credentials. BI Connector combines QlikSense’s powerful in-memory visualization capability with OBIEE’s strength in logical(metadata) and security model.
See how the BI Connector compares to other alternative options:
Watch for Qlik to OBIEE Video Tutorials:
If you are interested in evaluating and participating in the early customer program, email us at firstname.lastname@example.org.
Manage Reports List
The Manage Report list is a new self-service feature for developers and super users to facilitate easier loading of the reports catalog into Power BI, Tableau or Qlik. Visualization tools can show only 10,000 reports(objects) at a time and OBIEE is extremely inefficient with the catalog queries. The Manage Reports list overcomes these limitations and provides an easy way to offer a governed list of folders/reports available to end users.
The Manage Report feature is used as follows:
Using Manage Report List, super users/developers can provision a list of shared folders or reports to Power BI/Tableau/Qlik for development. The developers can either select existing folders such as /shared/GL or /shared/AR etc. Alternatively, the developer can create a folder called /shared/BI Connector and make this the folder of choice for Power BI.
By checking “Include My Reports folder”, the user’s reports in their personal folders are automatically displayed in Power BI.
Once the report is developed and published to Tableau Server/Power BI Cloud/QlikSense, it is automatically available for other users without any additional configuration.
Watch this video on how to configure OBIEE Reports DSN using BI Connector:
BI Connector | How to Configure Your OBIEE DSN - YouTube
Usability Enhancements for Tableau Extract
Users often find extracting OBIEE data with Tableau challenging and confounding. The issue lies in both Tableau and OBIEE.
Tableau queries for data extract are inefficient when compared to live queries. Extract queries fetch data for all the fields in multiple tables, often hundreds of fields, and fetch all the data which could run into millions of rows. Compare this to live queries which only fetch the required fields and allow you to add filters in an intuitive manner.
Most OBIEE environments cannot handle large data extracts. The maximum amount of data that can be extracted depends upon the hardware configuration of the OBIEE server. In addition, your OBIEE administrators might set limits on the maximum number of rows that can be exported.
Therefore users often see errors or no data when they try to extract from OBIEE Subject Areas. To avoid such errors, users need to limit the amount of data that will be extracted from OBIEE into Tableau. You can do this in two ways:
Limiting the number of columns being extracted,
Using filters to limit the number of rows.
Watch this video to learn the best practices for extracting OBIEE data with Tableau and BI Connector.
BI Connector | Best Practices to Extract OBIEE Data With Tableau - YouTube
BI Connector v3.7 includes enhancements that help users to manage the number of columns being extracted and the number of rows being extracted. By default, BI Connector will restrict queries to a maximum of 25 fields per query. Queries with more than 25 fields will automatically error out with an intuitive error message. Users will be guided to the best practices tutorial that shows how to limit the number of fields using Hide Unused fields feature in Tableau. Users can customize the maximum number of fields in the Settings UI of BI Connector.
In addition, users can use filters in Tableau to restrict the number of rows. Users can also set limits on the maximum number of rows fetched from OBIEE by using OBIEE session variables or in the BI Connector Settings UI. You can learn more about this in this How-to article.