vimpx:properties:sourceconnection

Source Connection

Property SourceConnectionEnabled

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

Property SourceAccessVersion

0 = Access
1 = Access2007 (or higher version)

Property SourceBrightPearlEmail

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 Visual Importer ETL it is possible to automate loading data from Brightpearl.

Following data can be extracted

Brand
https://www.brightpearl.com/developer/latest/product/brand/search.html

Brightpearl-category
https://www.brightpearl.com/developer/latest/product/brightpearl-category/search.html

Contact
https://www.brightpearl.com/developer/latest/contact/contact/search.html

Order

Search
https://www.brightpearl.com/developer/latest/order/order/search.html

List of fields
https://www.brightpearl.com/developer/latest/order/order/get.html

Option
https://www.brightpearl.com/developer/latest/product/option/search.html

Option-value
https://www.brightpearl.com/developer/latest/product/option%20value/search.html

Product
https://www.brightpearl.com/developer/latest/product/product/search.html

Product-type
https://www.brightpearl.com/developer/latest/product/product-type/search.html

Goods-in-note
https://www.brightpearl.com/developer/latest/warehouse/goods-in-note/search.html

Goods-out-note
https://www.brightpearl.com/developer/latest/warehouse/goods-out-note/search.html

Additional parameters can be passed using search string

As described here

https://www.brightpearl.com/developer/latest/tutorial/working-with-resource-search.html

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.

Property SourceBrightPearlSearchString

Property SourceCompress

Only relevant to MySql connection.

Property SourceDatabase

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

Property SourceDirectory

Use SourceDirectory to specify directory to load data from.

Property SourceDisableBulkFetch

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

Property SourceExcelVersion

0 = Excel
1 = Excel2007 (or higher version)

Property SourceFile

Use SourceFile to specify file to load data from.

Property SourceFileBlockLength

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

Property SourceFileBlocks

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

Property SourceFileDelimiter

Use SourceFileDelimiter to specify delimiter for source file.

Property SourceFileEncoding

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

Property SourceFileFirstField

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

Property SourceFileFooterLines

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

Property SourceFileHeaderLines

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

Property SourceFileIsCrossTable

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

Property SourceFileIsDelimited

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

Property SourceFileMask

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

Property SourceFileQuote

Use SourceFileQuote to specify Quote for source file.

Property SourceFileUseMask

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

Property SourceGoogleSpreadSheetNo

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

Property SourceIsTable

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

Property SourceNoOfRecordsToRead

Maximum number of records/lines to read

Property SourceNoOfTablesToRead

Maximum number of tables/files/sheets to read

Property SourceOracleConnectAs

0 = ocaNormal
1 = ocaSYSDBA
2 = ocaSYSOPER

Property SourcePassword

Use SourcePassword to specify password for source connection.

Leave it blank if you want to use ODBC connection string

Property SourcePort

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

Property SourceReadAllData

When true NumberOfRecordsToRead is ignored

Property SourceReadAllTables

When true NumberOfTablesToRead is ignored

Property SourceSalesForceClientId

  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:

https://www.salesforce.com/us/developer/docs/api/index_Left.htm#CSHID=sforce_api_calls_soql.htm|StartTopic=Content%2Fsforce_api_calls_soql.htm|SkinName=webhelp

Property SourceSalesForceClientSecret

Property SourceSalesForceSecurityToken

Property SourceSearchInSubdirectories

Works only when source is a file

Property SourceSelectStatement

Use SourceSelectStatement to specify SQL Statement to load data from.

Property SourceServer

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:

VImpAX1. SourceType = dsOracle;
VImpAX1.SourceServer=”ORCL”;
VImpAX1.SourceDatabase=”;
VImpAX1.SourceUserName=”scott”;
VImpAX1.SourcePassword=”tiger”; 
Example using ODBC Connection string:
 
VImpAX1. SourceType = dtODBC
VImpAX1.SourceServer=’uid=sa;pwd=;driver={SQL Server};server=(local);database=demo;’
VImpAX1.SourceDatabase=”;
VImpAX1.SourceUserName=”; -- must be blank when using ODBC connection string
VImpAX1.SourcePassword=”;  -- must be blank

Property SourceShowSystemTables

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

Property SourceSSLCACert

Works only with PostgreSQL and MySQL

Property SourceSSLCert

Works only with PostgreSQL and MySQL

Property SourceSSLKey

Works only with PostgreSQL and MySQL

Property SourceTable

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.

Property SourceTableMask

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

Property SourceTables

Use SourceTables to specify tables to load data from

Tables’ names must be delimited by semicolon.

Property SourceTimeOut

Connection timeout for OleDB.

Property SourceUseSSL

Property SourceType

0 = dsNone
1 = dsText
2 = dsODBC
3 = dsDbf
4 = dsAccess
5 = dsExcel
6 = dsSqlServer
7 = dsOracle
9 = dsMySql
10 = dsPostgreSQL
11 = dsInterbase
12 = dsOleDb
16 = dsSqLite
17 = dsXML
18 = dsSqlServerCE
22 = dsRSS
23 = dsGoogleSpreadsheet
27 = dsQVX
28 = dsEventLog
29 = dsSalesForce
30 = dsJDBC
32 = dsBrightPearl
34 = dsQVD
35 = dsBDE
36 = dsApplication

Property SourceTableUseMask

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

Property SourceUserName

Use SourceUserName to specify user name for source connection.

Leave it blank if you want to use ODBC connection string

Property SourceUseUnicode

Use SourceUseUnicode enable Unicode for MySQL, PostgreSQL and Sqlite

Property SourceXMLRecordTag

XML file example:

VimpX will also bring in all data between table and row tag.
For complex XML files it is also possible to apply XSLT transformations

XML Editor

To open XML editor click magnifying glass button

Property SourceXMLTableTag

Property SourceXMLTransformation

Property SourceXMLTransformationType

0 = xttNone
1 = xttXSLT

Property SourceFieldsCount

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

  • vimpx/properties/sourceconnection.txt
  • Last modified: 17/09/2018 10:30
  • by admin