Data Management, Data Query, Data Processing, Data Mining, Web Scraping and Data Reporting Software by Indigo DQM
Indigo DQM on LinkedIn Indigo DQM on Google+ Indigo DQM on Twitter Indigo DQM on Facebook
 
HOME ABOUT PRODUCTS SOLUTIONS SERVICES DOWNLOAD PURCHASE CONTACT
 
  Information ...IS POWER
The Ultimate Professional Data
Management
and Reporting
Software
from Indigo DQM
   
Data Queries and Processing
Data Reporting and Documents
Data Statistics and Analysis
Data Consolidation
Data Ingestion / Conversion
Data Filtering / Sorting
Data Migration
Data Warehousing
Data Mining / Harvesting
Data Transformation
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 Del.icio.usDel.icio.us 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


The Ultimate Data Management, Query, Processing and Reporting Software...
 
 
 
 
Indigo DQM Data Management System
Tel: 056 0364 1958