Page tree
Skip to end of metadata
Go to start of metadata

SFDC style

Welcome

The entire Jitterbit team is dedicated to your success!

We are constantly optimizing your experience with us. Be sure to visit often to browse through our growing library of documentation, guides and articles. Use the navigation links on the left side of this page or click a documentation category below to get started.

Jitterbit customers - If you need to open a support case or check on your case history, visit this link or click the "Submit a Case" button to the left.

Data Loader users - If you are looking for Data Loader support, please visit https://getsatisfaction.com/dataloader.

  • No labels

100 Comments

  1. Anonymous

    hi,

       i have used insert option.  and done successfully all process and after run display one message . this message successfully load the data but  i want to display target data in salesforce. how to display target data in salesforce when i have insert data using jitterbit data loader.

     

    1. Thank you for your comment.  Please submit all Data Loader questions to https://getsatisfaction.com/dataloader

  2. Anonymous

    Hi,

    I am constantly receiving emails from some guy in your company (probably sales department). And it's really annoying, so I'd like to unsubscribe from any newsletters etc. and remove my account on Jitterbit. But there's small problem: I don't remember a password. I tried to restore it, but I don't remember answer for secret question. Letter with validation code doesn't contain any instructions what I supposed to do if I don't know secret question's answer (probably you should make it more informative for such difficult cases). 

    Letter says

    If you are still having difficulty, please contact Jitterbit Support.

    But you forget to mention how exactly I should do it. I am not able to contact support because I am not able to login. The question is How I can restore my password? 

    1. We apologize for the inconvenience.  To unsubscribe from any Jitterbit mailing list, please send an email to info@jitterbit.com and include the name of your company and the email address to be removed.  For support on Data Loader, please submit all questions to https://getsatisfaction.com/dataloader.  To contact support for any other Jitterbit products, please go to https://success.jitterbit.com/display/DOC/Jitterbit+SuccessCentral for instructions.

  3. Anonymous

    Hello,

     

    What the volume of traffic that Jetterbit can support? Meaning how many transaction per second? What's the limitation (as there is always one)?

     

    Thanks

    1. API has specific hit allowances based on the License level selected by the customer.  Normal integration transactions are only limited by the number of servers (agents) the customer is using to process. Transaction volume is linearly scalable. If you have one server you can do x transactions per second, if you have 2 servers you can do 2x transactions per second, etc.  Additionally, Jitterbit utilizes Reliable Messaging architecture allowing one to run higher loads of transactions/spikes through a smaller scaled system at a cost of a slightly slower rate. To discuss your specific high volume use case, call Jitterbit at 1.877.852.3500 or email info@jitterbit.com

  4. Anonymous

    Hi,

    Is there any function in Jitterbit scripts for date difference ?

    i need to check if a date is in the last 5 days range.
    Thanks

    1. Hi,

      For examples of similar scripts, please go to Integration Pattern for Change Data Capture Using Timestamp Based Queries.

      Also, the following might be useful:

      $locks = FileList("<TAG>Sources/Locks</TAG>","locks","*");
      SortArray($locks);
      $locks;
      cnt = length($locks); i=0;
      While(i<cnt,
       $order = Split($locks[i],".");
       $orderno = $order[0];
       $now = (CVTDate(Now(),"yyyy-mm-dd HH:MM:SS","yyyymmddHHMMSS"));
       //set interval for 5 min, 300 sec;
       If(Double($now)-Double($order[1])>$deletelocktime,$del = true;WriteToOperationLog("order lock file to delete"+$orderno);DeleteFiles("<TAG>Sources/Locks</TAG>",$orderno+"*"),
       WriteToOperationLog("Locks: "+$locks+" below time limit")
       );
      i+=1);
      This example will be in a future post in our Design Pattern Library as well.
  5. Anonymous

    I have a CSV file in which the comma separated values are between the quotes (Ex: "NAME","","NUMBER","PHONE","FAX","ADDRESS"). When I try to use the BULK PROCESS in the jitterbit dataloader, it is throwing an error. When I tried removing the quotes, the file went through. But, we get files in the similar format everytime. Is there any way we can solve this without manually removing the quotes before the dataload?

    1. We have submitted your Data Loader question to https://getsatisfaction.com/dataloader.   Please go to https://getsatisfaction.com/dataloader and watch for the answer to your question.

      For support on Data Loader, please submit all questions to https://getsatisfaction.com/dataloader.  To contact support for any other Jitterbit products, please go to https://success.jitterbit.com/display/DOC/Jitterbit+SuccessCentral for instructions.

  6. Anonymous

    Hi,

    i'm finding it hard to configure the temporary storage for source and target for applying transformations and here are few questions related to that:

    1. How do i find which folder is been referenced in the temp folder of my local machine for the temporary storage in jitterbit?
    2. i'm on a jitterbit harmony trial license. I cant see the administrator console on my jitterbit studio. is it because of the trial license?
    3. is there a way that i could modify the jitterbit.conf ?

    Thanks

     

     

    1. 1. By default it is the system temp folder then \jitterbit. It can be overwritten in the Jitterbit config file ( jitterbit.conf). The settings are explained under the [Settings] tag in the config file.  Default install on Windows is  C:\Windows\Temp\jitterbit.

      2. There is no longer an Administrator Console all of the functionality has been moved to the Web Management Console accessed via www.Jitterbit.com.

      3. You can modify the Jitterbit config file directly. The default install on Windows is C:\Program Files (x86)\Jitterbit Agent\jitterbit.conf


      NOTE: Changing the Jitterbit config or configuration of the temp directory can only be done on a local agent.

  7. Anonymous

    Hi,

    I keep receiving the following error in a newly configured project for web services:

    "Get failed. SSL connect error. Unknown SSL protocol error in connection to wsapi.CLIENT.ca:443".

    I have confirmed the SSL setting ins the Source are correct, what else should I check? 

     

    1. First, please check these items:
      1. Verify that the private key certificate is valid and has not expired.
      2. You may be trying to connect using a cipher that the site does not support.  To verify, you would have to use tools that are designed to capture this type of information in order to determine what is an acceptable cipher to use.  Also, I believe Jitterbit no longer supports some of the SSL1 ciphers.  
      If these steps do not resolve your issue, please go to Getting Support and follow the instructions to submit a ticket to Support.
  8. Anonymous

    Hi,

    I am trying to use excel as Database and trying Database To Text Option.

    When I click on test connection, It shows success message but when I go further, it shows nothing in Available table list.

    Kindly help me with this.

    I am using 30 days Trial version For Harmony.

  9. Please send an email to support@jitterbit.com outlining the issue you are experiencing with your Trial version of Harmony. The Jitterbit Support Team will help you resolve this issue.

  10. Anonymous

    Well, I was going to register, but I get this error whenI try:

    • Your request cannot be processed at this time. The site administrator has been alerted.
    • The account associated with this portal has no owner

    Now here  is my real issue: I recently upgraded an integration project from 5.6 to Harmony. I have an operation that I can run manually - it runs fine. I have to run it on a schedule though , so I created a schedule and set the schedule on the operation, but it never fires. I tried several setting the schedule at different times, waited, with no effect. The project uses cloud agents. 

    Has anyone else run into this? Is anything that needs to be enabled/configured by Jitterbit on their end?

    Please help.

    Thank you.

    Vladimir Martinov

    1. Thank you for submitting a comment. We have checked with the Jitterbit Support Team and see that your comment has already been resolved.

  11. Anonymous

    I am running a query using Jitterbit that is supposed to return around 2700 rows. The query just sits there without returning. It seems it has hung. The Operation monitor just keeps updating, but the query never returns.

    Please help.

    1. Thank you for your comment. Please go to Getting Support and follow the instructions to submit a ticket to Support.

  12. Anonymous

    Can you help me on this error?

    Failed to connect to database. [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SqlState: 08001).

    Studio version: 8.15.0.2
    Studio platform: Windows 7 - Java 1.8.0_91
    Cloud: https://emea-west.jitterbit.com
    User: romeo.e.de.leon@accenture.com
    Org: Accenture [ID = 155558]
    Environment: Test [ID = 154058]
    Agent Group: Jitterbit Cloud Agent Group [ID = 1542] [Lowest Agent Version = 8.15.1.1]
    Project: New Project [GUID = 63a3b418-42f2-45f4-a92d-0d9df2d9866e]
    Timestamp: 2016-08-19 16:48:01.426

     

    1. We will need additional information in order to help you. Please go to Getting Support and follow the instructions to submit a ticket to Support.  

    2. Customer was using a Jitterbit Cloud Agent, so installed the local agent and then able to connect to his local database.

  13. Anonymous

    I am trying to create some Salesforce Queries using Jitterbit studio.

    The Objects which I plan to use are Case, order, Order Item, Asset.

    But I did not find the cosponsoring objects in JB studio - SF Query builder wizard. 

    1. Anonymous

      If you are looking for object WorkOrder then it will be available in the next version:

      Data Loader v8.13

      Harmony 8.16

      WorkOrder object has been exposed by Salesforce in SFDC API v37 which will be supported in above mentioned Jitterbit version

  14. Anonymous

    I am creating a new FTP Target and was wondering if it is possible to add the current date into the filename.  If so, how?

    1. Yes you can add the date to the filename.  All you need to do is add the [date] variable.

      EX:
      records[date].csv 

      1. Anonymous

        That helped, but is it possible to set the date format to yyyy.mm.dd instead of what it came in as 2016-Sep-2?

        1. Yes it is.  You will need to declare a variable in a script before the target, and use that variable in your target.

          $date=Now();         // 2016-09-02 12:25:25
          $date=CVTDate($date,"yyyy-mm-dd","yyyy.mm.dd");       // 2016.09.02

          To add a script to your operation, right click on the yellow dot before target, then click insert script

  15. Anonymous

    Hi Team,

    I am looking for Attachments Migration for one salesforce to other Instance. I am here in feel Jitterbit could be help me to this attachments migration more easily than traditional Data Loader. May be it is right but I am finding difficult to do this. Usually Attachments needs to CSV files where is CSV file we mention in Body column location of the file to be picked as we have downloaded all the files from Source.

    But when I tried Query Attachments for JitterBit I am getting a single with the Encoded content in the Body. Actually I have to change the ParentIds before importing them to the Target Salesforce which I could not able to do as CSV file messed up since it comes in Un understandble format.

    Could some guide me please for effective migration of attachments what should i follow in Jitter bit.

    Thanks in advance for looking at my case. I am glad If I could any help.

     

    Regards

    Sri 

    1. To download the attachment from SFDC you can have a script in the transformation mapping and save the file to a location:

      <trans>

      $content = Base64Decode(SFDC_SOURCE_FILE_COLUMN_NAME);

      $fn = SFDC_FILE_NAME;

      WriteFile("<TAG>Targets/FILE_CONNECTION</TAG>",$content,$fn);

      FlushFile("<TAG>Targets/FILE_CONNECTION</TAG>",$fn);

      </trans>

       

      To upload the file to Salesforce, it will be reverse and use Base64Encode function:

      <trans>

      $DynamicFileName = Some_File_Name_From_Source;

      $FileContent = ReadFile("<TAG>Sources/ATTACHEMENT_FILE_PATH</TAG>", $DynamicFileName);

      Base64Encode($FileContent);

      </trans>

       

       

       

  16. Anonymous

    Thanks for the Swift Reply Rakesh. Firstly Its new for me to know we can write scripts in Jitter Bit.  By the way Your example looks like in consideration of single attachment. I am sorry In my case I have to Migrate more than 10K files of course not at once..but in incremental way.

     

    Regards

    Sri

  17. Anonymous

    Hi Rakesh,

    I am sorry may i know where can i write the script. For your information I am Jitter Bit cloud data loader 8.7.4.37 version. Would this has feature to write transformation script, that's great if so may I know please how could navigate to that window.

    I appreciate your support

     

    Regards

    sri

     

    1. Please open the operation, go to the Mapping, Double click on the target column and it will open the formula builder where you can write the script.

       

  18. Anonymous

    Hi Rakesh,

    Its a bit confusing..where would we get Mapping while exporting I mean Querying in Jitter Bit. And one other thing was your srcipt example works dynamic i mean does take source file name from result of SOQL.

    Regards

    Sri

  19. Anonymous

    Thanks Rakesk I can see Mapping Editor on Queries as well. Apologies for reply without investigation. Its puzzling really how could i write dynamic transformation script to take attachments and import to other salesforce instance.

  20. Anonymous

    Hi Rakesh,

    Thanks for the active support. I am becoming favourite to this tool. Looks I could very easily migrate the attachments. As you suggested I did import where I have not got any physical copies to my Local directoy but csv file has got path of the Attachment in Body Column.

     

    Following is the script i have being used

    <trans>

    $content = Base64Decode(root$transaction.response$body$queryResponse$result$records.Attachment$Body$);
    $fn = root$transaction.response$body$queryResponse$result$records.Attachment$Name$;
    WriteFile("<TAG>Targets/FILE_CONNECTION</TAG>",$content,$fn);
    FlushFile("<TAG>Targets/FILE_CONNECTION</TAG>",$fn);

    </trans>

     

    I tried to insert same csv with the parentid and owner id modification where I have below script while inserting..

    <trans>
    $DynamicFileName = Body;
    $FileContent = ReadFile("<TAG>Sources/name</TAG>", $DynamicFileName);
    Base64Encode($FileContent);
    </trans>

     

    But I recieve error as rewuired fields "Body" missing. Could you please help me looks im also in reach to my target. dreaming i can all attachments so easily

  21. Anonymous

    Cheers. I am craked it. Hurray

  22. Anonymous

    I've almost got SQL Server set up correctly. The connection is successful and when I execute an operation that uses it in Harmony all is well. But in Jitterbit Studio I get this error when I try to load sample source data:

    Failed to load source data for the transformation: Unable to load database source data.
    DSN (password not shown) = 'SERVER=[server_name];DRIVER=SQL Server;DATABASE=[database_name];UID=;PWD=<REMOVED>;'
    Database error: Connecting to database failed. Last reported error: SqlState = 08001 NativeError = 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
    SQL Connect / SQL Driver Connect

    (DSN = ;Pwd=<REMOVED>;, User = , Driver = , Server = , DbName = , ConnectString = SERVER=[server_name];DRIVER=SQL Server;DATABASE=[database_name];UID=;PWD=<removed>;) [CODE:10084] file: OdbcSource.cpp, line 121 [State: , Native error: 0] [CODE:10148] file: TreeMapperRead.cpp, line 392

    What am I doing wrong? I am "including teh schema/owner in the table names". It didn't work without it either. 

    1. We will need additional information in order to help you. Please go to Getting Support and follow the instructions to submit a ticket to Support.  


  23. Anonymous

    Hi,

    my example works except for the last step. I create a several files and archive them. I have two problems at configuration of my target

    1. I use [date].zip to create my archive. I need another date format than YYYY-Mon-DD.
    2. For files I use [file].txt. The archive will be created and it contains the right files, but names of files are arbitrary and not the same like I created. Where and how can I fix it?
      1. Please create another global variable like ($FileName) in a script in the operation before transformation or before source and set the value of that variable using CVTDate function as per the required date format. And then use that global variable in the target file name like [FileName].zip
      2. Use the similar approach as above to resolve the issue.
        Else we might need to look at the operation. So please send a mail to support@jitterbit.com with questions.
  24. Anonymous

    When using the Diff functions is there a way to include records that failed last time we ran the job without resetting the Diff and reprocessing all records?

     

    For example, I just ran a upsert to Salesforce that successfully processed 3000+ records, but had 3 failures. I'd like to run the job again for just the three that failed, but when I re-run the process it says that there are no changes in the Diff so there is nothing to do.

     

    Are failed attempts still logged in the Diff, and therefore not able to be re-run without a change to them in the source?

  25. Anonymous

    1. The diff functions look at the source and not the target so it doesn't know about the failed records.
    2. To capture the failed records please pull up the operation, Right Click on the Operation, Select Options. you will get the Operations Option window. Here select the Write failure records to option and specify your target. 
    3. For future questions on support related items please email to support@jitterbit.com so we can help you more effectively. 
  26. Anonymous

    i am using JitterBit Cloud data loader to get csv file using FTP (from another system) to the Salesforce and then Insert that data into salesforce...but don't know why the data does not inserting successfully..

    Please Help !!

    1. For support issues related to Jitterbit Data Loader, please refer to this area:

      https://getsatisfaction.com/dataloader

      If you would like to learn about the full Harmony solution, please visit:

      http://www.jitterbit.com/harmony/

      Regards,

      Jitterbit Support

  27. Anonymous

    Hello Experts,

    I need help in doing this. Below is my situation.

    I have 2 datetime fileds in my source table Column A (Insert_Date) and Column B( Update_Date)

    My target is text file. I want to keep a filter in WHERE clause so that i can get only updated rows or new rows of data from the source. Below is the sql statement what i tried

    Select * from ABC

    WHERE GetUTCFormattedDate(Insert_Date,"PST", false) OR (GetUTCFormattedDate(Update_Date,"PST", false))>= GetUTCFormattedDate(now(),"CST", false) - 5. But, i am getting error

     Please kindly respond how to work around this. I sincerely appreciate your help.


     

    1. GetUTCFormattedDate is a Jitterbit function so it can't be used in SQL statement. So you need to create an global variable in a script before the source and set the date value using the GetUTCFormattedDate function something like:

      $DateFilter = GetUTCFormattedDate(now(),"CST", false) and apply the DateAdd function to reduce 5 (days or months hours as required).

      And then use that global variable in the SQL like:

      WHERE Insert_Date >= '[DateFilter{2016-01-01 09:09:09}]' OR Update_Date >= '[DateFilter{2016-01-01 09:09:09}]'

      The syntax to use the global variable in Manual SQL is as follows: [name_of_Global_Variable_without_$_sign{some_default_Value}]

       

      Here default value is being using at design time and at run time, actual value will replace it. For more information, please send a mail to support@jitterbit.com

  28. Anonymous

    @Rakesh Aggarwal

    I did gave a shot as you said and it seems it worked. Thank you for your suggestion. Below are the steps what i did. Hope it helps for future folks.

    1) I created a script and named it as DateScript. I wrote the script between        

         <trans>

                   $Datefilter = GetUTCFormattedDate(DateAdd('dd',-5,now()), "CST", false);

        </trans>

            Tested the result and it gave date 5 days before from current date. (in my case that is what i want)

     

    2) Added this script before the source. This is how you do

         Source component–> Right Click on Source component–> Choose option highlighted in yellow color "Insert After/before this" (Script).–> Chose DateScript that was created.

     

    3)Open the transformation—> Right Click Source Structure --> Choose Edit Source Structure --> Keep on clicking 'NEXT' button until you see SQL Where Clause --> In the WHERE clause write column A >=  '[DateFilter{2016-01-01 09:09:09}]' OR column B >= '[DateFilter{2016-01-01 09:09:09}]'. In my case column A and column B are Insertdate and Updatedate. Dont worry about the default date that is passed. As said above default value is being using at design time and at run time, actual value will replace it (which will be passed from the script to source). That is it after you done changes deploy the operation and run it you will see the data as expected.

    NOTE: This will be helpful mostly for SCD Type -2 logic. Hope this helps. Thanks to Rakesh from jitterbit

     

  29. Anonymous

    I was wondering if anyone knows the easy way to change the operation. I came across the situation where I spend several hours creating one operation and mapping lots of fields from source to destination and later found out that operation needs to be Upsert instead of Update. How can I change one operation to another back and forth without creating new one?

    Thank you.

     

    1. There is no way to convert the upsert operation into update. But you can export / import the mappings you have created in the transformation. Please open the transformation and right click in between source / target and choose Export ---> Export Mappings.

      After creating a new update operation, you can import the same mapping.

  30. Anonymous

    In my environment I need to whitelist any external IP addresses when going outbound... What IP addresses should I whitelist to use jitterbit?

    1. Please contact customersupport@jitterbit.com so we can gather more details about your use case and be sure you have the information you need. 

  31. Anonymous

    Hi,

    We are using Salesforce WSDL for inserting data from xml file to salesforce instead of Standard salesforce connector. We are getting invalid session id and not able to figure out how can we set call back url and session id? Please assist.


    Thanks

  32. Please add a script in the starting of the operation and call SalesforceLogin function which will set 2 variables session id and server URL in global variables which you need to use in the request part of the web service.

    Here is the documentation of this function:

    bool SalesforceLogin(string salesforce_org)

    Logs in to Salesforce, using the specified Salesforce Org.

    After a successful login, the following global data elements have been set and can be used in subsequent scripts or mappings:

    • $Salesforce.SessionID: The Salesforce session ID.
    • $Salesforce.ServerURL: The URL to use in subsequent calls to Salesforce in the same session.
    • $Salesforce.UserID: The ID of the Salesforce user.

    Returns true if the login was successful. Returns false if login failed. Call GetLastError() to get the error message.


    Please send a mail to support@jitterbit.com for further assistance, so that we can look at the jitterpak or come on a web meeting if required.

  33. Anonymous

    I was try to deploy 1 operation that I created. Then my colleague can't see or can't download the operation that I did.
     We are using the latest version Jitterbit Studio 8.20.0.4

    Any Idea to this problem.

    Thanks.

    1. Please be sure that you are both on the same Harmony org. If that is the case, please send a mail to support@jitterbit.com for further assistance.

  34. Anonymous


    File is not importing properly in salesforce professional ORG

    Hello!
    We are importing attachments with the help of Jitterbit in Salesforce professional ORG.
    It is importing, but everytime the size of attachment is 21 bytes.

    Wheresas, if we directly upload an attachment from "Notes and Attachment", it is importing properly!

    Please suggest.
    Contact : Dnyanesh - +91 9960607125 
    (9 AM to 7 PM IST)

    1. Anonymous

      Please contact customersupport@jitterbit.com so we can gather more details about your use case and be sure you have the information you need. 

  35. Anonymous

    Hi,

    Do you know if we can able to create a reference table in jitterbit? If Yes, how to create and use the reference table during mapping?

    I am on condition of transforming full country name to just 3 alphabet country code.

    For Example:

    Reference Table:

    INDIA - IND

    United States - USA

    If my country name is 'INDIA', then need to be lookup into the above reference table and get the value as 'IND'. This values should be the output for the Target field.

    1. Anonymous

      my email address: yuvarajs@unitedtechno.com

      1. Anonymous

        Please contact customersupport@jitterbit.com so we can gather more details about your use case and be sure you have the information you need. 

  36. Anonymous

    Hello, 


    I am trying to extract data from SAP using a BAPI function request in order to display it on a temporary file. When I run the operation I get the following message: 

    The operation "BAPI_XBP_GET_USER_LIST (2)" failed.

    Error
    Transformation 'BAPI_XBP_GET_USER_LIST - Request' failed.
    Fatal SAX error: invalid document structure

    XML file: C:/Windows/Temp/jitterbit/OpId_4008414_58aeb965-e587-4221-9ae6-12d6c27749d3/dataElement_t3942684_source
    Failed to perform transformation using local source file:
    C:/Windows/Temp/jitterbit/OpId_4008414_58aeb965-e587-4221-9ae6-12d6c27749d3/dataElement

    Fatal Error
    Transformation failed.

    Could you please help me ? 


    Thank you. 

  37. Anonymous

    Hi. That's not something that we can answer here. If you have a jitterbit support contract please email support@jitterbit.com to open a support case and we'll look at it with you. Thanks.

  38. Anonymous

    Hello,

    I am trying to create a variable to use as a counter that will be inserted as a database. I can run my operation once with success but once i try to run it again I get a duplicate value error in my database because the variable reverts back to its original value . How do I update my variable after each successful run of the operation to add 1 to the counter? I have tried inserting a script at the end of the operation to ass 1 to the counter but my code must be incorrect.

    Thank you for any assistance you can provide.

  39. Anonymous

    Hi. I assume that you're talking about a global variable. The scope of a global variable is within an operation chain, so when your operation chain finishes any global variables that you've set will lose their value. You could use a project variable for this, but project variables will keep their value for a maximum of thirty days if they aren't re-set, so if your operation ever went for that long without running you'd lose the value. If you can create a table in your database and store the counters there that's probably the best solution.

    1. Anonymous

      Thank you for your reply. I have tried a project variable as well but I find this is also resetting to its default value after running the operation successfully. 

      I will try creating a table in the DB for storage.

      Again, thank you for your reply.

  40. Anonymous

    Hi,


    Is it possible in Jitterbit to set up a dynamic end - to - end process.  e.g. provided with valid end connections, a table name and say a comma separated list of column names, get Jitterbit to pull data out of Salesforce and write it to SQL?


    I am not currently a jitterbit user but looking at it as a potential solution provider therefore have no knowledge of how Jitterbit works.


    Thanks

  41. Anonymous

    Hi. You can create a Salesforce query type operation in Jitterbit where the data source is Salesforce and the target is a database, but the list of columns that you want to include is fixed when you create or edit the Jitterbit operation. You can't dynamically change the list of columns that are included at run time.

  42. Anonymous

    Hi,

    I have a requirement where I have to ready a value from the column in csv file and then use this value somewhere in the operation. i.e. header name(Size) will contain a value. I have to use this value and compare it with another source file size (for this I will use Jitterbit standard size forumula). Has anyone worked on it before?


    Many thanks in advance.

    Regards,

    Mayank

    1. Anonymous

      Mayank, in order to read the value from your 1st CSV file you will need to create a transformation operation to pickup the file and then assign that value to a global variable.

      If you are trying to read the value in script and on the fly, it could be done but would involve a lot of scripting to do so.

      1. Anonymous

        Hi!! Thanks for your response. What would be the syntax to assign a value to a global variable from the current csv file? 

        Mayank

        1. Anonymous

          Mayank, please see below in regards to using global variables.

          Using Global Variables

          Thanks!

  43. Anonymous

    Hi, 

    Is there any process for connecting the digital asset management tool to salesforce via jitterbit.Please help.....................

     

    1. Jitterbit doesn't have a specific connector to connect to DAM but if DAM is exposing any web services or http rest APIs then it can be connected from Jitterbit.


  44. Anonymous

    Hi!! Does jitterbit supports PK chunking?


    Thanks,

    Mayank

  45. Anonymous

    Hi, Mayank. You mean in a salesforce bulk operation, correct? No, we don't support that.


    1. Anonymous

      okay.. Thanks. 

  46. Anonymous

    Hello, I have a quick question. I am trying to connect to a sql server database which is located on network server. Do i need to have jitterbit agent installed on my system locally, So that i can only connect to my source. Am i right ??

    1. Yes, you need to install the Agent on any machine which is on the same network.

      If you want to use Jitterbit Cloud Agent then you have to expose the SQL Server to Jitterbit Cloud through Firewall / network.

  47. Anonymous

    Hi I'm looking for integration of Woo Commerce to Microsoft Dynamics NAV

    1. JItterbit doesn't have any specific connector for Woo Commerce and Dynamics NAV.

      So if these systems have exposed any Soap Web Service / Rest API / Database Access then these can be integrated.

      For further assistance on this, please send a mail to support@jitterbit.com

  48. Anonymous

    Okay Thank you...

  49. Anonymous

    Hello,

    1) I have a issue while connecting to the Target database. I have jitterbit Agent installed on my local machine, there is another jitterbit agent that is installed on the client side too. I am using a Sql server database as a source from my machine. Let me tell you the source sql server database is on another server and the jitterbit agent is on my desktop. However i am able to connect to my source sql server database with instance and tested the connection sucessfully.

    Now, i am trying to insert some data into my Target which is also a sql server database that is sitting on my client server. I got all credentials from my client to connect to their database. So, when i entered all the credentials to connect to their Sql server database. I am getting a error as below:

    Failed to connect to database. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SqlState: IM002).

    2) Also, I want to bring this point when i use my clients Jitterbit agent i can connect to their sql server database as a Source. And when i keep the Target database as my sql server on our server under their Agent Group and agent. It gives below error:

    Failed to connect to database. [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (SqlState: 08001).


    Is there some kind of permissions issue going on...I could'nt find any helpful information in jitterbit support page too..

  50. This seems to be the Sql Server Database accessibility issue.All the Database connections are being made from the Agent machine.

    In Case 1: When you are using your Local agent then Agent is not able to access the Client's SQL server database (as Target). It might be inaccessible from your agent machine.

    In Case 2: When using Client Agent, then that agent is not able to access your SQL Server Database. That's why you keep getting the error: " Error Locating Server/Instance Specified [xFFFFFFFF]. (SqlState: 08001)."


    So it seems that your local agent & your Sql Server database are on one network and Client Agent & their SQL Server Database is on another Network and there might be no proper connectivity between these networks. You can try to ping the client's SQL Server Database from your Agent machine to verify (or vice versa).

    For further assistance, please send a mail to support@jitterbit.com using your official email id.

  51. Anonymous

    @Rakesh Aggrawal... Thank You very much for your expertise help.

    So, another quick question if i want to connect to my client sql server do they need to open any port over their firewall and allow jitterbit agent on my machine to connect to their sql server database and vice versa ... I already sent an email to jitterbit support though.. just want to get some more info for our notes..



    1. Yes, That's correct.

  52. Anonymous

    Hi,

    How can I set the date field to blank? When the date field in Salesforce is set to nothing, the date does not get updated in my database.

    Any suggestions?


  53. Anonymous

    @Rakesh Aggrawal

    Hi,

    How can I set the date field to blank? When the date field in Salesforce is set to nothing, the date does not get updated in my database.

    Any suggestions?

    1. Anonymous

      You will only be able to set this if your target allows for the date to be of that format. 
      If you are pushing to a target that has date as a datatype then you will not be able to do that. Only option would be to NULL out the field. 

  54. Anonymous

    Hi,

    If I perform Bulk Upsert operation in Salesforce through Jitterbit, does jitterbit return Batch Job and Batch Id for that bulk process? I am struggling to figure it out. 

    1. Anonymous

      Hello,

      After testing, it does not appear that the batch job or batch ID is returned to Jitterbit through a bulk process.

  55. Anonymous

    Hi,


    What's the difference between using a Jitterpak vs. downloading the project from the Harmony cloud?


    Thanks

    1. Anonymous

      A jitterpak is a backup of the operation as it exists on your local system and is relatively easily passable from computer to computer, whereas downloading a project pulls the active project from the agent and overwrites your local copy of it.

  56. Anonymous

    Hi, 

    It is possible to configure path for success and error files to  ftp servers when processes are running in local agents and not in cloud. My agent is running on UNIX servers and we don't want to store success and error logs there. If yes, then how?

    Thanks 


    1. Please right on the operation and go to Options. There is a section to Write the Success / Failure files to any other location. This configuration can be done if your source is a database or ASCII files.

  57. Anonymous

    How much is it mandatory to install Jitterbit agent on local system? 

    If some cases need to have Jitterbit Agent installed on local local system, can you please elaborate them?

    1. If all of the your source and target are on cloud like Salesforce, FTP etc then you don't need to install the local agent. In that case, you can use the Jitterbit Cloud Agent.

      But in case, if your source (like database, local file share etc) is installed on your office network and can't accessed from outside then you need to install the local agent. If you can open the port of these machines (database or file share) then you can work with Cloud agent.


      1. Anonymous

        Thank you!

        Now, I did an experiment where I installed 'x' driver to access 'y' database(not locally installed database). It ran successfully. I needed to install 'x' driver on my machine.

        In that case, I must have my local agent installed on that machine to access 'x' driver in case of 'database' as source, right?

        So, will I be able to get the same driver listed in New Source Wizard, if I have chosen to run my project on Jitterbit Cloud Agent?

        1. If you have any specific database where you need to have specific driver which is not listed as default in the Driver list (in studio) then you have to install the Local agent and install the same driver on that machine.

          Then it will appear on the studio. But you have to use Local agent (not the Jitterbit cloud agent group). You will not be able to install any driver if using Jitterbit Cloud Agent Group.

          For further assistance, please mail to support@jitterbit.com