Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Modified Sybase Connection?

  1. #1
    Join Date
    Oct 2010
    Posts
    8

    Question Modified Sybase Connection?

    Hi forum members,

    I am not a developer but "self-supported power user" of the ETL-features. I have a business-database based on Sybase with a weird setting. Long story short is:
    I need to specify tables names in the form of "IQF1.FK_Artikel" (the database is set up in some main/sub-database setting).

    After reading the source code I believe all I need is a copy of SybaseDatabaseMeta with the modification
    HTML Code:
    	 */
    	public String getSchemaTableCombination(String schema_name, String table_part)
    	{
    		return schema_name+"."+table_part;
    	}
    But: How do I implement a "custom database connection"? I googled, also with site:pentaho.com , but found no documentation. I did find
    http://type-exit.org/adventures-with...ormation-step/ and
    http://wiki.pentaho.com/display/COM/PDI+Plugin+Loading
    though, but I am not development-savvy enough to figure out the correct way for a custom database connection. (These links are about transformations.)

    Any (brief) tips or just links are greatly appreciated.
    I have a fresh Eclipse download.

    The software is a widely-used german accounting software called "Lexware" and I promise to write an article somewhere online about Pentaho&Lexware, as soon as I figured this out! *g*

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    you may have some luck specifying a "Generic Connection" with URL: jdbc:jtds:sybase://hostname:port/databaseName and database driver class net.sourceforge.jtds.jdbc.Driver

    This may work without having to touch code at all :)

    Cheers

    Slawo

  3. #3
    Join Date
    Oct 2010
    Posts
    8

    Default

    Ohh -- I think I now "owe you" a link to that article I promised!
    (It works! *hooray* Thank you very much indeed!)

    I did not even use the suggested configuration, I just edited the former ODBC-Connection. It kept these config values:
    Parameter Value
    Driver class sun.jdbc.odbc.JdbcOdbcDriver
    URL jdbcdbc:LXSYDSN;characterEncoding=utf8;useCursorFetch=true;defaultFetchSize=500

    I do have access via ODBC only, and even this access is limited. (Due to some severe vendor restrictions.)

  4. #4
    Join Date
    Sep 2009
    Posts
    810

    Default

    Looking forward to "Extracting data from Lexware with PDI"

  5. #5
    Join Date
    Oct 2010
    Posts
    8

    Default

    That's part 1, and the "inserting data" will be part 2!

    Just for reference, Lexware is widely enough used for 3rd party devs to offer an abundance of scripts like http://www.oscware.de/advanced_searc...exware&x=0&y=0 or http://aih.de/index.php?sec=6&sub=17 (and these are only 2 third parties out of _many_).

    But I do shovel data between an ERP on Firebird, some in-house data in MySQL, even an odd Excel-frontended-csv file -- so I cannot buy scripts from here&there. All I need is a Spoon-based ETL... And a little help from that reply above! *G*

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.