What are the database formats for SAS access to OBDC?

[CesarOmarHR]

Hi there

I know it's a pretty simple question, but what are the databases capable for import with SAS ACCESS TO OBDC?

I appreciate the help.

César

[LinusH]

Pretty much any database that has an odbc driver. There can be limitations to data types supported.  See on line doc for details.

[CesarOmarHR]

Do you know the data types that are supported?

i'm thinking MySql, Sql, .dat are there any others?

[Reeza]

Isn't .dat a text file, not a data base?

[jakarman]

Yep your are right Reeza CesarOmarHR is mixing up a lot. All three are really different:

- The rdbms system like MySql.

- A language you can use to access a rDBMS as SQL

- a text file in some text file (.dat) you can use to configure something like a rDBMS.

[jakarman]

I your question is wich RDBMS systems support ODBC. Well ODBC is an open standard they should conform to.

If at the RDBMS software supplier they are claiming to support this than that is no question. The only question is if they are conforming that correctly (no errors).

Be aware of the confusion on dedicated interfaces being supported. They are often indicated as ODBC but are dedicated versions with a lot of additional functionality. Sometimes these are not available on all platforms. For example SQL-server is having dedicated drives at Windows but you are needing to switch to ODBC at Unix.

Datatypes within each RDBMS type is another part of the puzzle. Not all datatypes are equal. The interface is doing the translations. They can be found at:  

SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition

As you can see it are the SAS-formats that are related to the data-type conversions. Numerics in SAS are always floating type. This is not the same within a RDBMS assuming numeric are equal to chars just having a dedicated range more like a constraint.
 

[Reeza]

I think Linus answer is correct, anything with an ODBC Driver.

And SQL isn't one thing, there's T-SQL or MS SQL, Oracle SQL, MySQL, NoSQL, SQLLite and I'm sure there are others.

[jakarman]

Open Database Connectivity - Wikipedia, the free encyclopedia