Data Management, Data Query, Data Processing, Data Mining, Web Scraping and Data Reporting Software by Indigo DQM
Indigo DQM on Facebook Indigo DQM on Google+ Indigo DQM on Twitter Indigo DQM on LinkedIn

Have you got the best BID???

Sell the best story of your Business Intelligence Data

With the Indigo DQM Data Powerhouse

Featuring Advanced Data Management, Reporting and AI

Data Management Overview
Data Reporting Overview
Data Management Tools
Data Queries and Processing
Data Reporting and Documents
Data Statistics and Analysis
Data Consolidation, Aggregation
Data Ingestion / Conversion
Data Mapping, Filtering / Sorting
Data Migration
Data Warehousing
Data Mining / Harvesting, ETL
Data AI, Machine Learning
Data Web Scraping
Data Interchanging
Data Backup and Restore
Data Security and Encryption
Indigo DQM Articles
Send to a Friend

Managing Data Sources

You can create a private Data Source that a specific Data Command Query or Execution Plan uses or a shared Data Source which all can use. For this example we shall create a shared Data Source. Select the Data Sources Tab from the Data Management Studio.

Indigo DQM supports multiple Data Sources and Types including Microsoft SQL Server, Microsoft Access, ODBC, OLEDB, MySQL, Oracle, Postgre, Firebird, XML and CSV making it transparent to virtually all Data Sources.

Data Source Connection

Specify the Data Source Connection parameters by selecting the Data Source Type and Connection String from the Connection Dialog.

Data Source Files

Data Source Files can be XML, CSV or TXT. These Data files can be local, files on a network or files located on the Internet / Intranet.

The URI properties of the Data Source allow the parameters to be defined for Host, User Name and Password if required.

Encrypted Data files can also be downloaded using HTTPS therefore securing Data transmission.

Enter the Host, Port and Path for the Data and the Security Credentials. If the Data is Encrypted with AES 256 Encryption then set the Encrypted Property to True. The Advanced Encryption System (AES) uses a 256-bit encryption key. The secure Key must be setup in the Program Settings and Options.

CSV Data Source File

The name "CSV" indicates the use of the comma to separate data fields. Nevertheless, the term "CSV" is widely used to refer a large family of formats, which differ in many ways. Some implementations allow or require single or double quotation marks around some or all fields; and some reserve the very first record as a header containing a list of field names.

Connection String for the CSV Data Source File.

CSV Data can use different characters as the separator and text qualifiers. These characters can be changed when setting up the Data Source to read CSV Data. Additionally some CSV may or may not have the first line of text as the column header which represents the name of the field in the Data Table.

All these options can be setup for the CSV Data Source thus ensuring complete compatibility with all CSV and Text Data Sources.

Pulling Data down from the Internet is a useful and powerful feature of Indigo DQM.

XML Data Source File

Specify the Location to the XML Data and the Data Source Connection Properties.

The Connection Properties of the XML Data File.

Enter the Host, Port and Path for the Data and the Security Credentials. If the Data is Encrypted with AES 256 Encryption then set the Encrypted Property to True.

Return to Articles


Share it:

Share this page on Share this page on DiggDigg Share this page on FacebookFacebook Share this page on GoogleGoogle Share this page on MyspaceMySpace Share this page on NewsvineNewsvine
Share this page on RedditReddit Share this page on StumbleuponStumbleupon Share this page on TechnoratiTechnorati Share this page on TwitterTwitter Share this page on Yahoo!Yahoo!

Discover Indigo DQM Download a Free Trial of Indigo DQM Data Management System
Safe downloads: McAfee SiteAdvisor
The Ultimate Data Management, Query, Processing and Reporting Software...
Download Indigo DQM Overview
Download Indigo DRS Overview
Download Indigo ICR Overview Logo
Top 5
Based On Client Reviews

Read all 4 Reviews / Write A Review Logo
The crowd rates us 5.0 out of 5.0

Read all 4 Reviews / Write A Review

What do you think about Indigo DQM Data Management and Reporting Systems ? Share your opinion on Cylex!
Indigo DQM Data Management System
Tel: 056 0364 1958