Getting Started
Introduction
Accessing the application
Supported Browsers
On-premise Vs Cloud based deployments
Installation and Setup
Creating an Amazon EMR cluster
Connecting Ideata to Amazon EMR cluster
Tuning Amazon EMR cluster
Creating an Amazon Redshift Cluster
Connect Ideata to Amazon Redshift cluster
Connect Your Data
Create a new connection
Prebuilt datasource connectors available in Ideata
Connect To Hadoop
Connect To MongoDB
Connect To Apache Cassandra
Connect To Amazon Redshift
Connect To IBM DashDB
Connect To IBM Cloudant
Add A Relational Databases
Upload CSV File
Upload Excel Spreadsheet
Upload Files and Folders from Amazon S3
Upload Server log files
Upload XML Files
Prepare And Transform Your Data
Overview
Preview sample data
Aggregate your data
Apply advanced mathematical formula
Change data type
Change text case
Duplicate a column
Count string patterns in a column
Transform Your Data
Cut string in a column
Delete a column
Extract Value from a column to a new column
Perform filter in a column
Perform geo-coordinate lookup for country and states
Import new sample data on data preview
Identify data types of a column
Perform join operations
Perform Lookup on a column
Remove duplicates in your data
Remove null values from a column
Rename a column
Perform replace operation in a column
Analyze column data distribution
Data quality analysis of a column
Perform split operation in a column
Trim whitespaces in a column
Explore data and build visualization
Add reference line on charts
Aggregate data on charts
Breakdown date parameters
Change chart colors
Change chart labels
Change Y axis format
Clear chart area
Export chart
Perform filters in your reports
How to highlight and concentrate on single data point
How to exclude values from your data
How to list top-n and bottom-n values in your data
How to select the dataset that you want to analyze
Perform slicing and dicing in your data
Join multiple tables for analysis
Rotate charts
Saving a report
Zoom into your data with subcharts
See underlying data of any chart
Select measure, dimension and group by paramentes for visualizations
Perform sort in your charts
Getting started with building charts and visualization
Create a bar chart
Create an area chart
Create a columnar chart
Create a donut chart
Create a funnel chart
Create a line chart
Create a mixed chart
Create a pie chart
Create a pyramid chart
Create a scatter chart
Create a spline chart
Create a stacked bar chart
Create a stacked column chart
Create a step chart
Create a data table
Create a treemap
Create a world map
Dashboards
Create a dashboard
Add report to dashboard
Add widgets
Edit an existing dashboard
Open existing dashboard
Remove reports from dashboard
Save dashboard
See full screen reports
Change ordering of reports
Administration and Upgrades
Installing Upgrades and patches
Getting Support
Published with GitBook

Add A Relational Databases

Previous: Connect To IBM Cloudant Next: Connect To MySQL Database