Tutorial

/Tag:Tutorial

Setting Up LDAP with Active Directory in PostgreSQL

In the example below, we are setting up LDAP with Active Directory (AD), one of the more popular server implementations, using the BigSQL PostgreSQL 96 distribution. Available for Windows and Linux. Download BigSQL Distribution Linux: python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" Windows: @powershell -NoProfile -ExecutionPolicy unrestricted -Command "iex ((new-object net.webclient).DownloadString('http://s3.amazonaws.com/pgcentral/install.ps1'))" Find the bigsql directory and install [...]

GDAL New Release 2.2 – BigSQL Makes it Easy to Install

The GDAL community just announced the release of GDAL 2.2... and BigSQL just made it easier to implement! Install it Now We support Diegos and Yodas with 2 ways to install: Option 1: Install with the pgDevOps GUI For GIS analysts (scientists, statisticians, analysts, etc) who find themselves as the de facto DBA (among other [...]

By | June 19th, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , , , , |0 Comments

The Easy Way to Setup PostgreSQL 10 Logical Replication

One of the most exciting enhancements that comes with the new PostgreSQL 10 release, is Logical Replication. The functionality, although not yet as extensive as pgLogical which it is based on, provides a powerful replication option when you want control over table backups at a finite level - allowing all kinds of ETL goodness like: [...]

By | June 7th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , |11 Comments

Install PostgreSQL 10 Today

Hey, have you heard? PostgreSQL 10 Beta is road ready! Kick the tires and take the cool new features and improvements out for a spin. Highlights include: Declarative Partitioning Logical Replication SCRAM Authentication See the full list of features here. Take the easy route Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy [...]

By | May 19th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , , , |2 Comments

Installing pgDevOps

Install in 6 easy steps Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy steps. Already have BigSQL pgc installed? Jump to step #3. Read this short introduction to BigSQL's package and update manager (pgc). Install pgc via command line to a sandbox: MAC / Linux: python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" Windows: @powershell [...]

ETL (Extract, Transform, Load) PostGIS Data with ogr2ogr

In an earlier post, I showed you how to use the shp2pgsql tool to import shapefiles into PostGIS. But what if you need to import other geodata formats (e.g. GeoJSON, MapInfo, KML, CSV, etc.)? ogr2ogr - ETL for PostGIS Lucky for you, the BigSQL PostGIS distribution comes bundled with GDAL and the ogr2ogr (or as [...]

By | April 24th, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , |2 Comments

Importing Shapefiles into PostGIS with shp2pgsql

Geojson may be catching up, but by and far the most popular data format for sharing geospatial data is (and has been since the early 1990's) the shapefile. Although a shapefile is a simple way to share data that can be easily consumed by almost any GIS system, it comes with many limitations and is [...]

By | March 23rd, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , |1 Comment

Tutorial on running Crystal Reports with BigSQL in Eclipse

1. Pre Requsites to run this tutorial: a) BigSQL Tutorial The BigSQL tutorial is required to be followed till the first three steps from the following link http://www.bigsql.org/se/tutorial.jsp Step 1 : Creating example.customer_history in HIVE and loading values. Step 2 : Creating example.customer_history as foreign table in Postgres Step 3 : Verifying example.customer_history b) Eclipse [...]

By | October 4th, 2013|Categories: BigSQL, Hadoop|Tags: , , , , , , |Comments Off on Tutorial on running Crystal Reports with BigSQL in Eclipse

JasperReports with Hadoop – Tutorial

This tutorial covers step by step instruction on running Jasper Reports with Hadoop using Jaspersoft Studio easy and simple to use environment . Also, publishing the created sample report with Jasperserver that is connected to Jaspersoft Studio . 1. Prerequisites a) BigSQL Tutorial is required to be followed till Step 3 http://www.bigsql.org/se/tutorial.jsp Step 1 : Creating example.customer_history [...]

By | September 25th, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG|Tags: , , , , , |Comments Off on JasperReports with Hadoop – Tutorial

Tutorial – Run BIRT against Hadoop

This tutorial covers setting up of BIRT (Business Intelligence Reporting Tool) to run against Hadoop. BIRT is a relatively simple and yet powerful analytics tool and the tutorial will help you harness the power against Hadoop. 1. Pre-Requisites BigSQL Tutorial The BigSQL Tutorial (http://www.bigsql.org/se/tutorial.jsp) needs to be followed till step 3 Step 1 : Creating example.customer_history [...]