Qlik Community

QlikView Connectors

Not applicable

OLEDB CONNECT Issue

I have a tab within the load script and the whole report fails as this part fails to connect to the Database. It will connect to the PROMOTION_REDEMPTION__C table in the same Database but wont connect to the CAMPAIGN one.  The Database is a Salesforce SQL Database:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=vrSalesforceVR1;Data Source=B2CSQL-01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BIC007033;Use Encryption for Data=False;Tag with column collation when possible=False];


BATS:
LOAD distinct promotionRedemptionID,
ID       as Redemption_ID,
    "REDEEMABLE_CAMPAIGN__C",
    'SF Tagged'       as BATS_Flag,
    "VOUCHER_CODE__C"    as barcode_number,
    "VOUCHER_CODE__C"    as Redemption_barcode_number
    ;
SQL SELECT promotionRedemptionID,
ID,
    "REDEEMABLE_CAMPAIGN__C",
    "VOUCHER_CODE__C"
FROM vrSalesforceVR1.dbo."PROMOTION_REDEMPTION__C";


Left Join (BATS)
LOAD ID        as REDEEMABLE_CAMPAIGN__C,
    NAME       as campaign_NAME,
    TYPE;
SQL SELECT Distinct ID,
NAME,
    TYPE
FROM vrSalesforceVR1.dbo.CAMPAIGN;

Community Browser