Source Connection

Use SourceConnectionEnabled to stop user from changing source connection properties via interface.

0 = Access
1 = Access2007 (or higher version)

Brightpearl is a fully integrated, web-based business management software system. It allows you to run all your business processes through one piece of software, so you no longer have to suffer the pain of transferring data between multiple different business systems. All your business's information is visible in real-time across every department whether it is entered via your website, inventory control, accounts or CRM. Until now the only way to prepare data for Data-warehouse was to export data manually. But today with help from Data Exchange Wizard it is possible to automate loading data from Brightpearl.

Following data can be extracted

brand
brightpearl-category
contact
order
List of fields
option
option-value
product
product-type
goods-in-note
goods-out-note

Columns

Each resource search supports a set of fixed set of columns - data that will be included in your results like contact names and email addresses. By default, every result will include a value for each column (although that value may be null) it is possible to change the set and order of the columns returned in the results.

It is also possible to constrain the search by specifying one or more column names as query parameters in your resource search URI.

For example:

primaryEmail=brightpearl.com&firstName=Ben

will only include results where the contact's email address contains brightpearl.com and their first name contains Ben.

Only relevant to MySql connection.

Use SourceDatabase to specify database name for MS Sql Server, PostgreSQL, MySql or Interbase and service for BrightPearl connection

Use SourceDirectory to specify directory to load data from.

Use SourceDisableBulkFetch to disable bulk fetch for ODBC connection. (Some of old ODBC drivers do not support this feature)

0 = Excel
1 = Excel2007 (or higher version)

Use SourceFile to specify file to load data from.

Use SourceFileBlockLength to specify length of block within Cross/Pivot table.

Use SourceFileBlocks to specify number of blocks within Cross/Pivot table.

Use SourceFileDelimiter to specify delimiter for source file.

0 = ftAuto 
1 = ftAsci
2 = ftUTF8
3 = ftUTF16LSB
4 = ftUTF16MSB

Use SourceFileFirstField to specify starting point of Cross/Pivot table.

Use SourceFileFooterLines to specify how many lines to skip at the end of the file.

Use SourceFileHeaderLines to specify how many lines to skip at the beginning of the file before loading data.

Use SourceFileCrossTable to specify whether source file is Cross/Pivot table or not.

Use SourceFileDelimited to specify whether source file is delimited or not.

Use SourceFileMask to specify mask to find files to load data from.

Use SourceFileQuote to specify Quote for source file.

Use SourceFileUseMask to specify whether use mask to find files to load data from or not.

Note: If you delete the sheet the sheet number will stay the same.

If you are having any problems please contact support and we will do our best to help you

Use SourceIsTable to specify whether source is a table or SQL Statement.

Maximum number of records/lines to read

Maximum number of tables/files/sheets to read

0 = ocaNormal
1 = ocaSYSDBA
2 = ocaSYSOPER

Use SourcePassword to specify password for source connection.

Note:

Leave it blank if you want to use ODBC connection string

Use Port to specify tcp/ip port for PostgreSQL or MySql.

When true NumberOfRecordsToRead is ignored

When true NumberOfTablesToRead is ignored

Note:

1. To get customer key and Customer secret login into SalesForce, click develop, click Remote access authentication. To get security token click my personal information, reset security token.
2. SalesForce support subset of SQL more information can be found here: http://www.salesforce.com/us/developer/docs/api/index_Left.htm#CSHID=sforce_api_calls_soql.htm|StartTopic=Content%2 Fsforce_api_calls_soql.htm|SkinName=webhelp 

Works only when source is a file

Use SourceSelectStatement to specify SQL Statement to load data from.

When Source type is 
Oracle - TNS NANE or Instant Client Connection String
MS Sql Server – server name
ODBC – ODBC Dsn or connection string
Ole DB – Ole DB connection string

Example:

DEWizadAX1. SourceType = dsOracle;
DEWizadAX1.SourceServer=”ORCL”;
DEWizadAX1.SourceDatabase=”;
DEWizadAX1.SourceUserName=”scott”;
DEWizadAX1.SourcePassword=”tiger”; 

Example using ODBC Connection string:

DEWizadAX1. SourceType = dtODBC
DEWizadAX1.SourceServer=’uid=sa;pwd=;driver={SQL Server};server=(local);database=demo;’
DEWizadAX1.SourceDatabase=”;
DEWizadAX1.SourceUserName=”; -- must be blank when using ODBC connection string
DEWizadAX1.SourcePassword=”;  -- must be blank

Use SourceShowSystemTables to specify whether to show system tables in Data Reader dialog or not.

Works only with PostgreSQL and MySQL

Works only with PostgreSQL and MySQL

Works only with PostgreSQL and MySQL

Use SourceTable to specify table to display data from.

For example User could specify several tables to load data from in SourceTables and only one to display in SourceTable.

Use SourceTableMask to specify mask to find tables to load data from.

Use SourceTables to specify tables to load data from Tables’ names must be delimited by semicolon.

Connection timeout for OleDB.

0   = dsNone
1   = dsText
2   = dsODBC 
3   = dsDbf
4   = dsAccess
5   = dsExcel
6   = dsSqlServer
7   = dsOracle
9   = dsMySql
10 = dsPostgreSQL 
11 = dsInterbase
12 = dsOleDB 

Use SourceTableUseMask to specify whether use mask to find tables/sheets to load data from or not.

Use SourceUserName to specify user name for source connection.

Note:

Leave it blank if you want to use ODBC connection string
Use SourceUseUnicode enable Unicode for MySQL, PostgreSQL and Sqlite

Xml file example:

Note:

DEWizadX will also bring in all data between table and row tag.
For complex XML files it is also possible to apply XSLT transformations
0 = xttNone
1 = xttXSLT

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • dewizardx/properties/sourceconnection.txt
  • Last modified: 17/09/2018 09:44
  • by admin